/*
 Date: 21/12/2023 18:53:00
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for ls_account_log
-- ----------------------------
DROP TABLE IF EXISTS `ls_account_log`;
CREATE TABLE `ls_account_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `sn` varchar(32) NOT NULL DEFAULT '' COMMENT '流水单号',
  `user_id` int(11) NOT NULL COMMENT '会员id',
  `change_type` smallint(5) NOT NULL COMMENT '变动类型',
  `action` tinyint(1) NOT NULL DEFAULT '0' COMMENT '动作:1-增加；0-减少',
  `change_amount` decimal(10,2) NOT NULL COMMENT '变动数量',
  `left_amount` decimal(10,2) NOT NULL DEFAULT '100.00' COMMENT '变动后数量',
  `association_sn` varchar(255) DEFAULT NULL COMMENT '关联单号',
  `remark` varchar(255) DEFAULT '' COMMENT '备注',
  `feature` text COMMENT '预留扩展字段',
  `create_time` int(10) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(10) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户账户记录表';

-- ----------------------------
-- Records of ls_account_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_ad
-- ----------------------------
DROP TABLE IF EXISTS `ls_ad`;
CREATE TABLE `ls_ad` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) NOT NULL DEFAULT '' COMMENT '广告标题',
  `pid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '广告位ID',
  `image` varchar(255) NOT NULL COMMENT '广告图',
  `link_type` tinyint(1) unsigned DEFAULT '1' COMMENT '链接类型：1-商城页面；2-商品页面；3-自定义链接',
  `link_address` varchar(255) DEFAULT '' COMMENT '链接地址：ad_type为1时，保存商城页面路径id；ad_type为2时，保存商品id；ad_type为3时，保存自定义链接',
  `status` tinyint(1) unsigned DEFAULT '1' COMMENT '广告状态：1-启用；0-停用',
  `sort` int(5) DEFAULT '0' COMMENT '排序',
  `create_time` int(10) DEFAULT NULL COMMENT '添加时间',
  `update_time` int(10) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(10) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COMMENT='广告表';

-- ----------------------------
-- Records of ls_ad
-- ----------------------------
BEGIN;
INSERT INTO `ls_ad` (`id`, `name`, `pid`, `image`, `link_type`, `link_address`, `status`, `sort`, `create_time`, `update_time`, `delete_time`) VALUES (1, '全能软件测试工程师', 1, 'uploads/images/202206061513266359d7125.jpg', 1, '1', 1, 0, 1654499693, 1654499693, NULL);
INSERT INTO `ls_ad` (`id`, `name`, `pid`, `image`, `link_type`, `link_address`, `status`, `sort`, `create_time`, `update_time`, `delete_time`) VALUES (2, 'NGINX官方认证考试', 1, 'uploads/images/202206061513240092e2642.jpg', 1, '1', 1, 0, 1654499759, 1654499759, NULL);
INSERT INTO `ls_ad` (`id`, `name`, `pid`, `image`, `link_type`, `link_address`, `status`, `sort`, `create_time`, `update_time`, `delete_time`) VALUES (3, '年中蓄力，年末涨价', 1, 'uploads/images/20220606151321577772005.jpg', 1, '1', 1, 0, 1654499806, 1654499806, NULL);
INSERT INTO `ls_ad` (`id`, `name`, `pid`, `image`, `link_type`, `link_address`, `status`, `sort`, `create_time`, `update_time`, `delete_time`) VALUES (4, '千元Get大项目实战，超值微体系课', 1, 'uploads/images/20220606151318106956854.jpg', 1, '1', 1, 0, 1654499869, 1654499869, NULL);
INSERT INTO `ls_ad` (`id`, `name`, `pid`, `image`, `link_type`, `link_address`, `status`, `sort`, `create_time`, `update_time`, `delete_time`) VALUES (5, '好课限时抢，抽奖赢免单', 1, 'uploads/images/202206061513153cb719329.jpg', 1, '1', 1, 0, 1654499915, 1654499915, NULL);
COMMIT;

-- ----------------------------
-- Table structure for ls_ad_position
-- ----------------------------
DROP TABLE IF EXISTS `ls_ad_position`;
CREATE TABLE `ls_ad_position` (
  `id` int(3) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(60) NOT NULL DEFAULT '' COMMENT '广告位置名称',
  `attr` tinyint(2) NOT NULL DEFAULT '2' COMMENT '广告位属性：1-系统默认；2-自定义；',
  `status` tinyint(1) unsigned DEFAULT '1' COMMENT '状态：1-启用；0-停用；',
  `create_time` int(10) DEFAULT NULL COMMENT '添加时间',
  `update_time` int(10) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(10) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='广告位表';

-- ----------------------------
-- Records of ls_ad_position
-- ----------------------------
BEGIN;
INSERT INTO `ls_ad_position` (`id`, `name`, `attr`, `status`, `create_time`, `update_time`, `delete_time`) VALUES (1, '首页轮播图', 1, 1, 1644546600, 1644831222, NULL);
INSERT INTO `ls_ad_position` (`id`, `name`, `attr`, `status`, `create_time`, `update_time`, `delete_time`) VALUES (2, '个人中心广告图', 1, 1, 1644546600, 1644831222, NULL);
COMMIT;

-- ----------------------------
-- Table structure for ls_admin
-- ----------------------------
DROP TABLE IF EXISTS `ls_admin`;
CREATE TABLE `ls_admin` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `root` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否超级管理员 0-否 1-是',
  `name` varchar(32) NOT NULL DEFAULT '' COMMENT '名称',
  `avatar` varchar(255) NOT NULL DEFAULT '' COMMENT '用户头像',
  `account` varchar(32) NOT NULL DEFAULT '' COMMENT '账号',
  `password` varchar(32) NOT NULL COMMENT '密码',
  `role_id` int(11) NOT NULL DEFAULT '0' COMMENT '角色id',
  `login_time` int(10) DEFAULT NULL COMMENT '最后登录时间',
  `login_ip` varchar(15) DEFAULT '' COMMENT '最后登录ip',
  `multipoint_login` tinyint(1) unsigned DEFAULT '1' COMMENT '是否支持多处登录：1-是；0-否；',
  `disable` tinyint(1) unsigned DEFAULT '0' COMMENT '是否禁用：0-否；1-是；',
  `create_time` int(10) NOT NULL COMMENT '创建时间',
  `update_time` int(10) DEFAULT NULL COMMENT '修改时间',
  `delete_time` int(10) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='管理员表';

-- ----------------------------
-- Records of ls_admin
-- ----------------------------
BEGIN;
INSERT INTO `ls_admin` (`id`, `root`, `name`, `avatar`, `account`, `password`, `role_id`, `login_time`, `login_ip`, `multipoint_login`, `disable`, `create_time`, `update_time`, `delete_time`) VALUES (1, 1, '超级管理员', '/api/static/default_avatar.png', 'admin', '61f5c424216318f20e10c9f8cdb6fc20', 0, 1663811677, '116.22.163.164', 1, 0, 1652859314, 1663811677, NULL);
COMMIT;

-- ----------------------------
-- Table structure for ls_admin_session
-- ----------------------------
DROP TABLE IF EXISTS `ls_admin_session`;
CREATE TABLE `ls_admin_session` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `admin_id` int(11) unsigned NOT NULL COMMENT '用户id',
  `terminal` tinyint(1) NOT NULL DEFAULT '1' COMMENT '客户端类型：1-pc管理后台 2-mobile手机管理后台',
  `token` varchar(32) NOT NULL COMMENT '令牌',
  `update_time` int(10) DEFAULT NULL COMMENT '更新时间',
  `expire_time` int(10) NOT NULL COMMENT '到期时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `admin_id_client` (`admin_id`,`terminal`) USING BTREE COMMENT '一个用户在一个终端只有一个token',
  UNIQUE KEY `token` (`token`) USING BTREE COMMENT 'token是唯一的'
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='管理员会话表';

-- ----------------------------
-- Records of ls_admin_session
-- ----------------------------
BEGIN;
INSERT INTO `ls_admin_session` (`id`, `admin_id`, `terminal`, `token`, `update_time`, `expire_time`) VALUES (1, 1, 1, '77c41cb213d9dbd684ff7ec0e0a688c4', 1663811677, 1663840477);
COMMIT;

-- ----------------------------
-- Table structure for ls_album
-- ----------------------------
DROP TABLE IF EXISTS `ls_album`;
CREATE TABLE `ls_album` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `cid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '类目ID',
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '管理员ID',
  `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
  `type` tinyint(2) unsigned NOT NULL DEFAULT '10' COMMENT '文件类型: 10=图片,  20=视频',
  `name` varchar(100) NOT NULL DEFAULT '' COMMENT '文件名称',
  `uri` varchar(200) NOT NULL COMMENT '文件路径',
  `ext` varchar(10) NOT NULL DEFAULT '' COMMENT '文件扩展',
  `size` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文件大小',
  `duration` int(11) NOT NULL DEFAULT '0' COMMENT '时长',
  `is_delete` int(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除: 0=否, 1=是',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `delete_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='相册管理表';

-- ----------------------------
-- Records of ls_album
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_album_cate
-- ----------------------------
DROP TABLE IF EXISTS `ls_album_cate`;
CREATE TABLE `ls_album_cate` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父级ID',
  `type` tinyint(2) unsigned NOT NULL DEFAULT '10' COMMENT '类型: 10=图片，20=视频',
  `name` varchar(32) NOT NULL DEFAULT '' COMMENT '分类名称',
  `is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除: 0=否, 1=是',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `delete_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='相册分类表';

-- ----------------------------
-- Records of ls_album_cate
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_article
-- ----------------------------
DROP TABLE IF EXISTS `ls_article`;
CREATE TABLE `ls_article` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `cid` int(10) unsigned NOT NULL COMMENT '分类',
  `title` varchar(200) NOT NULL DEFAULT '' COMMENT '标题',
  `intro` varchar(200) NOT NULL DEFAULT '' COMMENT '简介',
  `summary` varchar(200) DEFAULT '' COMMENT '摘要',
  `image` varchar(200) NOT NULL DEFAULT '' COMMENT '封面',
  `content` text COMMENT '内容',
  `author` varchar(32) NOT NULL DEFAULT '' COMMENT '作者',
  `visit` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '浏览',
  `sort` int(10) unsigned NOT NULL DEFAULT '50' COMMENT '排序',
  `is_show` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否显示: 0=否, 1=是',
  `is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除: 0=否, 1=是',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `delete_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `cid_idx` (`cid`) USING BTREE COMMENT '分类索引'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文章资讯表';

-- ----------------------------
-- Records of ls_article
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_article_category
-- ----------------------------
DROP TABLE IF EXISTS `ls_article_category`;
CREATE TABLE `ls_article_category` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(60) NOT NULL DEFAULT '' COMMENT '名称',
  `sort` smallint(5) unsigned NOT NULL DEFAULT '50' COMMENT '排序',
  `is_show` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否显示: 0=否, 1=是',
  `is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除: 0=否, 1=是',
  `create_time` int(10) unsigned DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned DEFAULT '0' COMMENT '更新时间',
  `delete_time` int(10) unsigned DEFAULT '0' COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文章分类表';

-- ----------------------------
-- Records of ls_article_category
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_article_collect
-- ----------------------------
DROP TABLE IF EXISTS `ls_article_collect`;
CREATE TABLE `ls_article_collect` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
  `article_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文章ID',
  `is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `delete_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文章收藏表';

-- ----------------------------
-- Records of ls_article_collect
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_config
-- ----------------------------
DROP TABLE IF EXISTS `ls_config`;
CREATE TABLE `ls_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(30) DEFAULT NULL COMMENT '类型',
  `name` varchar(60) NOT NULL DEFAULT '' COMMENT '名称',
  `value` text COMMENT '值',
  `create_time` int(10) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COMMENT='配置表';

-- ----------------------------
-- Records of ls_config
-- ----------------------------
BEGIN;
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (1, 'official_account', 'menu', '[{\"name\":\"阿萨德\",\"type\":\"view\",\"has_menu\":false,\"key\":\"\",\"url\":\"qwe.con\",\"appid\":\"\",\"pagepath\":\"\",\"sub_button\":[]}]', 1654055790, 1654055790);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (2, 'config', 'register_way', '[\"1\"]', 1654652368, 1654652368);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (3, 'config', 'login_way', '[]', 1654652368, 1657619426);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (4, 'config', 'is_mobile_register_code', '0', 1654652368, 1657619426);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (5, 'config', 'coerce_mobile', '0', 1654652368, 1657619426);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (6, 'config', 'h5_wechat_auth', '1', 1654652368, 1654652368);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (7, 'config', 'h5_auto_wechat_auth', '1', 1654652368, 1654652368);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (8, 'config', 'mnp_wechat_auth', '1', 1654652368, 1654652368);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (9, 'config', 'mnp_auto_wechat_auth', '1', 1654652368, 1654652368);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (10, 'config', 'app_wechat_auth', '0', 1654652368, 1657619426);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (11, 'mnp_settings', 'name', '知识付费', 1654654184, 1654654184);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (12, 'mnp_settings', 'original_id', '', 1654654184, 1654654184);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (13, 'mnp_settings', 'qr_code', '', 1654654184, 1654654184);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (14, 'mnp_settings', 'app_id', 'wx06dcXXXX5923adf', 1654654184, 1654654184);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (15, 'mnp_settings', 'app_secret', '4c218486XXXXXXX7f3bf7a4b2dd234a', 1654654184, 1654654184);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (16, 'website', 'name', '知识付费系统', 1655084406, 1661826813);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (17, 'website', 'web_favicon', 'uploads/images/20220914094749101f39002.png', 1655084406, 1663120072);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (18, 'website', 'web_logo', 'uploads/images/2022083010331032d4d6686.png', 1655084406, 1661826799);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (19, 'website', 'login_image', 'resource/image/adminapi/default/login_image.png', 1655084406, 1655084406);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (20, 'transaction', 'cancel_unpaid_orders', '1', 1655273984, 1671546051);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (21, 'transaction', 'verification_orders', '1', 1655273984, 1655273984);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (22, 'transaction', 'cancel_unpaid_orders_times', '30', 1655273984, 1671546051);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (23, 'transaction', 'verification_orders_times', '24', 1655273984, 1655273984);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (24, 'recharge', 'open', '1', 1655273984, 1672147768);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (25, 'recharge', 'min_amount', '0.01', 1655710284, 1672147768);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (26, 'customer_service', 'qr_code', '', 1655719312, 1655719312);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (27, 'customer_service', 'wechat', '123345', 1655719312, 1655719319);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (28, 'customer_service', 'phone', '123231', 1655719312, 1657004173);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (29, 'customer_service', 'service_time', '12343431', 1655719312, 1657004173);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (30, 'copyright', 'info', '', 1656662948, 1656662948);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (31, 'copyright', 'icp_number', '', 1656662948, 1656662948);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (32, 'copyright', 'icp_link', '', 1656662948, 1656662948);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (33, 'copyright', 'public_number', '', 1656662948, 1656662948);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (34, 'copyright', 'public_link', '', 1656662948, 1656662948);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (35, 'agreement', 'service_title', '112313', 1657262690, 1657262690);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (36, 'agreement', 'service_content', '', 1657262690, 1657262913);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (37, 'agreement', 'privacy_title', '12321', 1657262691, 1657262691);
INSERT INTO `ls_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (38, 'agreement', 'privacy_content', '<p>231311111111</p>', 1657262691, 1657262691);
COMMIT;

-- ----------------------------
-- Table structure for ls_consumption_incentives
-- ----------------------------
DROP TABLE IF EXISTS `ls_consumption_incentives`;
CREATE TABLE `ls_consumption_incentives` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `order_id` int(10) DEFAULT NULL,
  `user_id` int(10) DEFAULT NULL,
  `reward_type` tinyint(1) DEFAULT NULL,
  `reward_content` varchar(255) DEFAULT NULL,
  `delete_time` int(10) DEFAULT NULL,
  `create_time` int(10) DEFAULT NULL,
  `update_time` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of ls_consumption_incentives
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_coupon
-- ----------------------------
DROP TABLE IF EXISTS `ls_coupon`;
CREATE TABLE `ls_coupon` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL COMMENT '优惠券标题',
  `icon` varchar(255) DEFAULT NULL COMMENT '图片',
  `used` tinyint(2) DEFAULT NULL COMMENT '1：全场可用；2：指定课程可用；3：指定课程不可用',
  `type` tinyint(2) DEFAULT NULL COMMENT '1：满减券；2：叠加满减券；3：无门槛券（需要限制大小）',
  `receiving_method` tinyint(1) DEFAULT NULL COMMENT '1：用户领取；2：系统赠送',
  `full_amount` decimal(10,2) DEFAULT NULL COMMENT '满多少金额',
  `amount` decimal(10,2) DEFAULT NULL COMMENT '券额',
  `is_quota` tinyint(1) DEFAULT NULL COMMENT '是否限额1：是；0:不限制',
  `quota` int(10) DEFAULT NULL COMMENT '配额：发券数量',
  `take_type` tinyint(1) DEFAULT NULL COMMENT '1：不限制；2:用户只能领n张；3用户每天只能领n张',
  `take_quota` int(10) DEFAULT NULL COMMENT '配额：领取数量',
  `take_count` int(10) DEFAULT NULL COMMENT '已领取的优惠券数量',
  `used_count` int(10) DEFAULT NULL COMMENT '已使用的优惠券数量',
  `start_time` int(11) DEFAULT NULL COMMENT '发放开始时间',
  `end_time` int(11) DEFAULT NULL COMMENT '发放结束时间',
  `valid_type` tinyint(1) DEFAULT NULL COMMENT '时效:1：绝对时效（领取后XXX-XXX时间段有效）；2：相对时效（领取后当天起N天有效）；3：相对时效（领取后次日起N天有效）',
  `valid_start_time` int(11) DEFAULT NULL COMMENT '使用开始时间，结合vaild_type使用',
  `valid_end_time` int(11) DEFAULT NULL COMMENT '使用结束时间，结合vaild_type使用',
  `valid_days` int(3) DEFAULT NULL COMMENT '自领取之日起有效天数',
  `status` tinyint(1) DEFAULT '1' COMMENT '1：未开始；2：进行中；3：已结束',
  `auto_grant` tinyint(1) DEFAULT NULL COMMENT '0:非自动；1:自动',
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  `delete_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of ls_coupon
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_coupon_course
-- ----------------------------
DROP TABLE IF EXISTS `ls_coupon_course`;
CREATE TABLE `ls_coupon_course` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `coupon_id` int(10) unsigned DEFAULT NULL,
  `course_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of ls_coupon_course
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_coupon_receive
-- ----------------------------
DROP TABLE IF EXISTS `ls_coupon_receive`;
CREATE TABLE `ls_coupon_receive` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned DEFAULT NULL COMMENT '领取人id',
  `issuer` varchar(50) DEFAULT NULL COMMENT '发放人',
  `coupon_id` int(10) unsigned DEFAULT NULL COMMENT '优惠券id',
  `full_amount` decimal(10,2) DEFAULT NULL COMMENT '满多少金额',
  `amount` decimal(10,2) DEFAULT NULL COMMENT '券额',
  `status` tinyint(1) DEFAULT NULL COMMENT '1：已使用；0：已领取未使用；-1：为已过期；2：作废',
  `receive_time` bigint(11) DEFAULT NULL COMMENT '领取时间',
  `used_order_id` int(10) DEFAULT NULL,
  `start_time` bigint(11) DEFAULT NULL,
  `used_time` bigint(11) DEFAULT NULL COMMENT '使用时间',
  `expire_time` bigint(11) DEFAULT NULL COMMENT '过期时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=145 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of ls_coupon_receive
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_coupon_used
-- ----------------------------
DROP TABLE IF EXISTS `ls_coupon_used`;
CREATE TABLE `ls_coupon_used` (
  `id` int(10) DEFAULT NULL,
  `user_id` int(10) unsigned DEFAULT NULL COMMENT '买家id',
  `coupon_receive_id` int(10) unsigned DEFAULT NULL COMMENT '买家优惠券的领取记录id',
  `order_id` int(10) unsigned DEFAULT NULL COMMENT '订单id',
  `order_sn` char(36) DEFAULT NULL COMMENT '订单号',
  `total_amount` decimal(10,2) DEFAULT NULL COMMENT '订单原价',
  `coupon_amount` decimal(10,2) DEFAULT NULL COMMENT '优惠的金额',
  `order_amount` decimal(10,2) DEFAULT NULL COMMENT '订单优惠后的金额',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `delete_time` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of ls_coupon_used
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_course
-- ----------------------------
DROP TABLE IF EXISTS `ls_course`;
CREATE TABLE `ls_course` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `type` tinyint(1) NOT NULL COMMENT '类型：1-图文；2-音频；3-视频；4-专栏',
  `name` varchar(128) NOT NULL COMMENT '课程名称',
  `category_id` int(10) NOT NULL COMMENT '分类id',
  `teacher_id` int(10) NOT NULL COMMENT '讲师id',
  `synopsis` varchar(255) NOT NULL COMMENT '简介',
  `cover` varchar(255) NOT NULL COMMENT '课程封面',
  `content` text NOT NULL COMMENT '课程内容',
  `fee_type` tinyint(1) NOT NULL COMMENT '收费方式：1-收费；0-免费',
  `sell_price` decimal(10,2) DEFAULT NULL COMMENT '售价',
  `line_price` decimal(10,2) DEFAULT NULL COMMENT '划线价',
  `virtual_study_num` int(10) DEFAULT '0' COMMENT '虚拟学习人数',
  `study_num` int(10) DEFAULT '0' COMMENT '学习人数',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态：1-上架；0-下架',
  `is_choice` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否精选；1-是；0-否',
  `sort` int(10) NOT NULL COMMENT '排序',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='课程表';

-- ----------------------------
-- Records of ls_course
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_course_catalogue
-- ----------------------------
DROP TABLE IF EXISTS `ls_course_catalogue`;
CREATE TABLE `ls_course_catalogue` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `course_id` int(10) NOT NULL COMMENT '课程id',
  `name` varchar(64) NOT NULL COMMENT '目录名称',
  `fee_type` tinyint(1) NOT NULL COMMENT '收费方式：1-收费；0-免费',
  `cover` varchar(255) NOT NULL COMMENT '封面',
  `content` text NOT NULL COMMENT '内容',
  `sort` int(10) NOT NULL DEFAULT '0' COMMENT '排序',
  `status` tinyint(1) NOT NULL,
  `duration` int(11) DEFAULT '0' COMMENT '时长',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='课程目录';

-- ----------------------------
-- Records of ls_course_catalogue
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_course_category
-- ----------------------------
DROP TABLE IF EXISTS `ls_course_category`;
CREATE TABLE `ls_course_category` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL COMMENT '分类名称',
  `level` tinyint(1) NOT NULL COMMENT '级别：1-一级，2-二级',
  `pid` int(10) NOT NULL DEFAULT '0' COMMENT '父级id，0-为没父级',
  `image` varchar(128) NOT NULL COMMENT '分类图片',
  `sort` int(10) DEFAULT NULL COMMENT '排序',
  `status` tinyint(1) NOT NULL COMMENT '状态：1-显示，0-不显示',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='课程分类';

-- ----------------------------
-- Records of ls_course_category
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_course_collect
-- ----------------------------
DROP TABLE IF EXISTS `ls_course_collect`;
CREATE TABLE `ls_course_collect` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) NOT NULL COMMENT '用户id',
  `course_id` int(10) NOT NULL COMMENT '课程id',
  `create_time` int(11) NOT NULL COMMENT '收藏时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='课程收藏表';

-- ----------------------------
-- Records of ls_course_collect
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_course_column
-- ----------------------------
DROP TABLE IF EXISTS `ls_course_column`;
CREATE TABLE `ls_course_column` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `course_id` int(10) NOT NULL COMMENT '课程id',
  `relation_id` int(10) NOT NULL COMMENT '关联id(课程id)',
  `fee_type` int(10) NOT NULL COMMENT '收费方式：1-收费；0-免费',
  `sort` int(10) NOT NULL COMMENT '排序',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='专栏课程关联表';

-- ----------------------------
-- Records of ls_course_column
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_course_comment
-- ----------------------------
DROP TABLE IF EXISTS `ls_course_comment`;
CREATE TABLE `ls_course_comment` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `order_id` int(10) DEFAULT NULL COMMENT '订单id',
  `course_id` int(128) NOT NULL COMMENT '课程id',
  `user_id` int(10) NOT NULL COMMENT '用户id',
  `course_score` tinyint(1) DEFAULT NULL COMMENT '评分 1 一星 2 二星 3三星 4四星 5五星',
  `comment` varchar(255) DEFAULT NULL COMMENT '评论内容',
  `reply` varchar(255) DEFAULT NULL COMMENT '回复',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(10) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='评论表';

-- ----------------------------
-- Records of ls_course_comment
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_course_comment_image
-- ----------------------------
DROP TABLE IF EXISTS `ls_course_comment_image`;
CREATE TABLE `ls_course_comment_image` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `comment_id` int(10) NOT NULL COMMENT '评价id',
  `uri` varchar(128) DEFAULT NULL COMMENT '图片',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='评论图片表';

-- ----------------------------
-- Records of ls_course_comment_image
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_course_image
-- ----------------------------
DROP TABLE IF EXISTS `ls_course_image`;
CREATE TABLE `ls_course_image` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `course_id` int(10) NOT NULL COMMENT '课程id',
  `uri` varchar(128) NOT NULL COMMENT '轮播图链接',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='课程轮播图表';

-- ----------------------------
-- Records of ls_course_image
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_course_material
-- ----------------------------
DROP TABLE IF EXISTS `ls_course_material`;
CREATE TABLE `ls_course_material` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `course_id` int(10) NOT NULL COMMENT '课程id',
  `content` varchar(255) NOT NULL COMMENT '资料',
  `file_name` varchar(255) DEFAULT NULL COMMENT '资料名称',
  `link` varchar(255) DEFAULT NULL COMMENT '网盘链接',
  `code` varchar(16) DEFAULT NULL COMMENT '网盘密码',
  `is_link` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否强制网盘下载：1-是；0-否',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='课件资料';

-- ----------------------------
-- Records of ls_course_material
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_decorate_page
-- ----------------------------
DROP TABLE IF EXISTS `ls_decorate_page`;
CREATE TABLE `ls_decorate_page` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `type` tinyint(2) unsigned NOT NULL DEFAULT '10' COMMENT '页面类型',
  `name` varchar(100) NOT NULL DEFAULT '' COMMENT '页面名称',
  `data` text COMMENT '页面数据',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='页面装修表';

-- ----------------------------
-- Records of ls_decorate_page
-- ----------------------------
BEGIN;
INSERT INTO `ls_decorate_page` (`id`, `type`, `name`, `data`, `create_time`, `update_time`) VALUES (1, 1, '首页', '[{\"id\":\"la645ebtgkbrz\",\"title\":\"搜索\",\"name\":\"search\",\"disabled\":1,\"content\":{},\"styles\":{}},{\"id\":\"la645ebt06iz7\",\"title\":\"首页轮播图\",\"name\":\"banner\",\"content\":{\"enabled\":0,\"data\":[{\"image\":\"/api/static/banner01.png\",\"name\":\"likeshop\",\"link\":{\"path\":\"/pages/as_us/as_us\",\"name\":\"关于我们\",\"type\":\"shop\"}}]},\"styles\":{}},{\"id\":\"la645ebt47f2l\",\"title\":\"导航菜单\",\"name\":\"nav\",\"content\":{\"enabled\":0,\"data\":[{\"image\":\"/api/static/tabber_my.png\",\"name\":\"我的课程\",\"link\":{\"path\":\"/pages/study/index\",\"name\":\"我的课程\",\"type\":\"shop\"}}]},\"styles\":{}},{\"id\":\"la645ebtjxgdo\",\"title\":\"专区设置\",\"name\":\"special\",\"content\":{\"enabled\":2,\"title\":\"专题活动\",\"data\":[]},\"styles\":{}}]', 1661757188, 1672388382);
INSERT INTO `ls_decorate_page` (`id`, `type`, `name`, `data`, `create_time`, `update_time`) VALUES (2, 2, '个人中心', '[{\"id\":\"la645ebtii009\",\"title\":\"用户信息\",\"name\":\"user-info\",\"disabled\":1,\"content\":{},\"styles\":{}},{\"id\":\"la645ebtlhjyg\",\"title\":\"顶部图标\",\"name\":\"top-icon\",\"content\":{\"enabled\":1,\"title\":\"我的服务\",\"data\":[{\"name\":\"我的课程\",\"secName\":\"我的课程\",\"linkName\":\"我的课程\",\"link\":\"/pages/study/index\",\"image\":\"/api/static/user-center-study.png\"},{\"name\":\"我的订单\",\"secName\":\"我的订单\",\"linkName\":\"我的订单\",\"link\":\"/bundle/pages/order_list/index\",\"image\":\"/api/static/user-center-order.png\"},{\"name\":\"钱包余额\",\"secName\":\"钱包余额\",\"linkName\":\"钱包余额\",\"link\":\"/bundle/pages/user_wallet/index\",\"image\":\"/api/static/user-center-balance.png\"}]},\"styles\":{}},{\"id\":\"la645ebthm9cu\",\"title\":\"我的服务\",\"name\":\"my-service\",\"content\":{\"style\":1,\"title\":\"我的服务\",\"showTitle\":false,\"data\":[{\"image\":\"/api/static/contact.png\",\"name\":\"联系客服\",\"link\":{\"path\":\"/pages/customer_service/customer_service\",\"name\":\"联系客服\",\"type\":\"shop\"}},{\"image\":\"/api/static/wdsc.png\",\"name\":\"我的收藏\",\"link\":{\"path\":\"/bundle/pages/collection_list/index\",\"name\":\"我的收藏\",\"type\":\"shop\"}},{\"image\":\"/api/static/wdpj.png\",\"name\":\"我的评价\",\"link\":{\"path\":\"/bundle/pages/evaluate_list/index\",\"name\":\"评价管理\",\"type\":\"shop\"}},{\"image\":\"/api/static/gywm.png\",\"name\":\"关于我们\",\"link\":{\"path\":\"/pages/as_us/as_us\",\"name\":\"关于我们\",\"type\":\"shop\"}}]},\"styles\":{}},{\"id\":\"la645ebtyarmn\",\"title\":\"个人中心广告图\",\"name\":\"user-banner\",\"content\":{\"enabled\":0,\"data\":[{\"image\":\"https://java-szff-admin.yixiangonline.com/api/uploads/image/20221103/9254bfa7-e5a5-43fd-997f-fb81e67d44f2.png\",\"name\":\"\",\"link\":{\"path\":\"/bundle/pages/evaluate_list/index\",\"name\":\"评价管理\",\"type\":\"shop\"}}]},\"styles\":{}}]', 1661757188, 1672454981);
INSERT INTO `ls_decorate_page` (`id`, `type`, `name`, `data`, `create_time`, `update_time`) VALUES (3, 3, '客服设置', '[{\"title\":\"客服设置\",\"name\":\"customer-service\",\"content\":{\"title\":\"添加客服二维码\",\"time\":\"早上 9:00 - 22:00\",\"mobile\":\"13800138000\",\"qrcode\":\"\"},\"styles\":{}}]', 1661757188, 1672397375);
COMMIT;

-- ----------------------------
-- Table structure for ls_decorate_tabbar
-- ----------------------------
DROP TABLE IF EXISTS `ls_decorate_tabbar`;
CREATE TABLE `ls_decorate_tabbar` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(20) NOT NULL DEFAULT '' COMMENT '导航名称',
  `selected` varchar(200) NOT NULL DEFAULT '' COMMENT '未选图标',
  `unselected` varchar(200) NOT NULL DEFAULT '' COMMENT '已选图标',
  `link` varchar(200) DEFAULT NULL COMMENT '链接地址',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8mb4 COMMENT='底部装修表';

-- ----------------------------
-- Records of ls_decorate_tabbar
-- ----------------------------
BEGIN;
INSERT INTO `ls_decorate_tabbar` (`id`, `name`, `selected`, `unselected`, `link`, `create_time`, `update_time`) VALUES (85, '首页', '/api/static/tabbar_home_sel.png', '/api/static/tabbar_home.png', '{\"path\":\"/pages/index/index\",\"name\":\"首页\",\"type\":\"shop\"}', 1672397751, 1672397751);
INSERT INTO `ls_decorate_tabbar` (`id`, `name`, `selected`, `unselected`, `link`, `create_time`, `update_time`) VALUES (86, '分类', '/api/static/tabbar_list_sel.png', '/api/static/tabbar_list.png', '{\"path\":\"/pages/category/index\",\"name\":\"分类页面\",\"type\":\"shop\"}', 1672397751, 1672397751);
INSERT INTO `ls_decorate_tabbar` (`id`, `name`, `selected`, `unselected`, `link`, `create_time`, `update_time`) VALUES (87, '课程', '/api/static/tabbar_study_sel.png', '/api/static/tabbar_study.png', '{\"path\":\"/pages/study/index\",\"name\":\"我的课程\",\"type\":\"shop\"}', 1672397751, 1672397751);
INSERT INTO `ls_decorate_tabbar` (`id`, `name`, `selected`, `unselected`, `link`, `create_time`, `update_time`) VALUES (88, '我的', '/api/static/tabbar_my_sel.png', '/api/static/tabbar_my.png', '{\"path\":\"/pages/user/user\",\"name\":\"个人中心\",\"type\":\"shop\"}', 1672397751, 1672397751);
COMMIT;

-- ----------------------------
-- Table structure for ls_dev_crontab
-- ----------------------------
DROP TABLE IF EXISTS `ls_dev_crontab`;
CREATE TABLE `ls_dev_crontab` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL COMMENT '定时任务名称',
  `type` tinyint(1) NOT NULL COMMENT '类型：1-定时任务',
  `system` tinyint(4) DEFAULT '0' COMMENT '是否系统任务：0-否；1-是；',
  `remark` varchar(255) DEFAULT '' COMMENT '备注',
  `command` varchar(64) NOT NULL COMMENT '命令内容',
  `params` varchar(64) DEFAULT '' COMMENT '参数',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态：1-运行；2-停止；3-错误；',
  `expression` varchar(64) NOT NULL COMMENT '运行规则',
  `error` varchar(256) DEFAULT NULL COMMENT '运行失败原因',
  `last_time` int(11) DEFAULT NULL COMMENT '最后执行时间',
  `time` varchar(64) DEFAULT '0' COMMENT '实时执行时长',
  `max_time` varchar(64) DEFAULT '0' COMMENT '最大执行时长',
  `create_time` int(10) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(10) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='定时任务表';

-- ----------------------------
-- Records of ls_dev_crontab
-- ----------------------------
BEGIN;
INSERT INTO `ls_dev_crontab` (`id`, `name`, `type`, `system`, `remark`, `command`, `params`, `status`, `expression`, `error`, `last_time`, `time`, `max_time`, `create_time`, `update_time`, `delete_time`) VALUES (1, '关闭超时未支付的订单', 1, 0, '关闭超时未支付的订单', 'order_close', '', 1, '0 */1 * * * ?', '', 1672398360, '0.01', '0.45', 1655973568, 1672398360, NULL);
INSERT INTO `ls_dev_crontab` (`id`, `name`, `type`, `system`, `remark`, `command`, `params`, `status`, `expression`, `error`, `last_time`, `time`, `max_time`, `create_time`, `update_time`, `delete_time`) VALUES (2, '退款单日志', 1, 0, '退款单日志', 'order_refund', '', 1, '0 */1 * * * ?', NULL, 1672398360, '0.01', '0.45', 1655973568, 1672398360, NULL);
COMMIT;

-- ----------------------------
-- Table structure for ls_dev_navigation
-- ----------------------------
DROP TABLE IF EXISTS `ls_dev_navigation`;
CREATE TABLE `ls_dev_navigation` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL COMMENT '导航名称',
  `selected_icon` varchar(255) NOT NULL COMMENT '选中图标',
  `un_selected_icon` varchar(255) NOT NULL COMMENT '未选中图标',
  `selected_color` varchar(255) NOT NULL COMMENT '选中字体颜色',
  `un_selected_color` varchar(255) NOT NULL COMMENT '未选中字体颜色',
  `create_time` int(10) NOT NULL COMMENT '创建时间',
  `update_time` int(10) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(10) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='底部导航表';

-- ----------------------------
-- Records of ls_dev_navigation
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_dev_notice_setting
-- ----------------------------
DROP TABLE IF EXISTS `ls_dev_notice_setting`;
CREATE TABLE `ls_dev_notice_setting` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `scene_id` int(10) NOT NULL COMMENT '场景id',
  `scene_name` varchar(255) NOT NULL DEFAULT '' COMMENT '场景名称',
  `scene_desc` varchar(255) NOT NULL DEFAULT '' COMMENT '场景描述',
  `recipient` tinyint(1) NOT NULL DEFAULT '1' COMMENT '接收者 1-买家 2-卖家',
  `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '通知类型: 1-业务通知 2-验证码',
  `system_notice` text COMMENT '系统通知设置',
  `sms_notice` text COMMENT '短信通知设置',
  `oa_notice` text COMMENT '公众号通知设置',
  `mnp_notice` text COMMENT '小程序通知设置',
  `support` char(10) NOT NULL DEFAULT '' COMMENT '支持的发送类型 1-系统通知 2-短信通知 3-微信模板消息 4-小程序提醒',
  `update_time` int(10) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COMMENT='通知设置表';

-- ----------------------------
-- Records of ls_dev_notice_setting
-- ----------------------------
BEGIN;
INSERT INTO `ls_dev_notice_setting` (`id`, `scene_id`, `scene_name`, `scene_desc`, `recipient`, `type`, `system_notice`, `sms_notice`, `oa_notice`, `mnp_notice`, `support`, `update_time`) VALUES (1, 100, '注册验证码', '用户注册时发送', 1, 2, '{\"type\":\"system\",\"title\":\"\",\"content\":\"\",\"status\":\"0\",\"is_show\":false,\"tips\":[\"可选变量 验证码:code\"]}', '{\"type\":\"sms\",\"template_id\":\"SMS_175615071\",\"content\":\"您正在申请注册，验证码${code}，切勿将验证码泄露于他人，本条验证码有效期5分钟。\",\"status\":\"1\",\"is_show\":true,\"tips\":[\"可选变量 验证码:code\",\"示例：您正在申请注册，验证码${code}，切勿将验证码泄露于他人，本条验证码有效期5分钟。\",\"生效条件：1、管理后台完成短信设置。 2、第三方短信平台申请模板 3、若是腾讯云模板变量名须换成变量名出现顺序对应的数字(例：您好{nickname},您的订单{order_sn}已发货! 须改为 您好{1},您的订单{2}已发货!)\"]}', '{\"type\":\"oa\",\"template_id\":\"\",\"template_sn\":\"\",\"name\":\"\",\"first\":\"\",\"remark\":\"\",\"tpl\":[],\"status\":\"0\",\"is_show\":false,\"tips\":[\"可选变量 验证码:code\",\"配置路径：小程序后台 > 功能 > 订阅消息\"]}', '{\"type\":\"mnp\",\"template_id\":\"\",\"template_sn\":\"\",\"name\":\"\",\"tpl\":[],\"status\":\"0\",\"is_show\":false,\"tips\":[\"可选变量 验证码:code\",\"配置路径：小程序后台 > 功能 > 订阅消息\"]}', '2', NULL);
INSERT INTO `ls_dev_notice_setting` (`id`, `scene_id`, `scene_name`, `scene_desc`, `recipient`, `type`, `system_notice`, `sms_notice`, `oa_notice`, `mnp_notice`, `support`, `update_time`) VALUES (2, 101, '登录验证码', '用户手机号码登录时发送', 1, 2, '{\"type\":\"system\",\"title\":\"\",\"content\":\"\",\"status\":\"0\",\"is_show\":false,\"tips\":[\"可选变量 验证码:code\"]}', '{\"type\":\"sms\",\"template_id\":\"SMS_222458159\",\"content\":\"您正在登录，验证码${code}，切勿将验证码泄露于他人，本条验证码有效期5分钟。\",\"status\":\"1\",\"is_show\":true,\"tips\":[\"可选变量 验证码:code\",\"示例：您正在登录，验证码${code}，切勿将验证码泄露于他人，本条验证码有效期5分钟。\",\"生效条件：1、管理后台完成短信设置。 2、第三方短信平台申请模板 3、若是腾讯云模板变量名须换成变量名出现顺序对应的数字(例：您好{nickname},您的订单{order_sn}已发货! 须改为 您好{1},您的订单{2}已发货!)\"]}', '{\"type\":\"oa\",\"template_id\":\"\",\"template_sn\":\"\",\"name\":\"\",\"first\":\"\",\"remark\":\"\",\"tpl\":[],\"status\":\"0\",\"is_show\":false,\"tips\":[\"可选变量 验证码:code\",\"配置路径：小程序后台 > 功能 > 订阅消息\"]}', '{\"type\":\"mnp\",\"template_id\":\"\",\"template_sn\":\"\",\"name\":\"\",\"tpl\":[],\"status\":\"0\",\"is_show\":false,\"tips\":[\"可选变量 验证码:code\",\"配置路径：小程序后台 > 功能 > 订阅消息\"]}', '2', NULL);
INSERT INTO `ls_dev_notice_setting` (`id`, `scene_id`, `scene_name`, `scene_desc`, `recipient`, `type`, `system_notice`, `sms_notice`, `oa_notice`, `mnp_notice`, `support`, `update_time`) VALUES (5, 104, '找回登录密码验证码', '用户找回登录密码号码时发送', 1, 2, '{\"type\":\"system\",\"title\":\"\",\"content\":\"\",\"status\":\"0\",\"is_show\":false,\"tips\":[\"可选变量 验证码:code\"]}', '{\"type\":\"sms\",\"template_id\":\"SMS_175615069\",\"content\":\"您正在找回登录密码，验证码${code}，切勿将验证码泄露于他人，本条验证码有效期5分钟。\",\"status\":\"1\",\"is_show\":true,\"tips\":[\"可选变量 验证码:code\",\"示例：您正在找回登录密码，验证码${code}，切勿将验证码泄露于他人，本条验证码有效期5分钟。\",\"生效条件：1、管理后台完成短信设置。 2、第三方短信平台申请模板 3、若是腾讯云模板变量名须换成变量名出现顺序对应的数字(例：您好{nickname},您的订单{order_sn}已发货! 须改为 您好{1},您的订单{2}已发货!)\"]}', '{\"type\":\"oa\",\"template_id\":\"\",\"template_sn\":\"\",\"name\":\"\",\"first\":\"\",\"remark\":\"\",\"tpl\":[],\"status\":\"0\",\"is_show\":false,\"tips\":[\"可选变量 验证码:code\",\"配置路径：小程序后台 > 功能 > 订阅消息\"]}', '{\"type\":\"mnp\",\"template_id\":\"\",\"template_sn\":\"\",\"name\":\"\",\"tpl\":[],\"status\":\"0\",\"is_show\":false,\"tips\":[\"可选变量 验证码:code\",\"配置路径：小程序后台 > 功能 > 订阅消息\"]}', '2', NULL);
INSERT INTO `ls_dev_notice_setting` (`id`, `scene_id`, `scene_name`, `scene_desc`, `recipient`, `type`, `system_notice`, `sms_notice`, `oa_notice`, `mnp_notice`, `support`, `update_time`) VALUES (7, 106, '订单付款通知', '订单付款成功时通知买家', 2, 1, '{\"type\":\"system\",\"title\":\"订单付款\",\"content\":\"亲爱的{nickname}，您的订单 {order_sn}已支付成功，商家正在快马加鞭为您安排发货。\",\"status\":\"1\",\"is_show\":true,\"tips\":[\"可选变量 用户昵称:nickname 订单编号:order_sn 支付时间:pay_time\",\"亲爱的{nickname}，您的订单 {order_sn}已支付成功，商家正在快马加鞭为您安排发货。\"]}', '{\"type\":\"sms\",\"template_id\":\"SMS_222463029\",\"content\":\"亲爱的${nickname}，您的订单${order_sn}已支付成功，商家正在快马加鞭为您安排发货。\",\"status\":\"0\",\"is_show\":true,\"tips\":[\"可选变量 用户昵称:nickname 订单编号:order_sn 支付时间:pay_time\",\"示例：亲爱的${nickname}，您的订单${order_sn}已支付成功，商家正在快马加鞭为您安排发货。\",\"生效条件：1、管理后台完成短信设置。 2、第三方短信平台申请模板 3、若是腾讯云模板变量名须换成变量名出现顺序对应的数字(例：您好{nickname},您的订单{order_sn}已发货! 须改为 您好{1},您的订单{2}已发货!)\"]}', '{\"type\":\"oa\",\"template_id\":\"\",\"template_sn\":\"\",\"name\":\"\",\"first\":\"\",\"remark\":\"\",\"tpl\":[],\"status\":\"0\",\"is_show\":true,\"tips\":[\"可选变量 用户昵称:nickname 订单编号:order_sn 支付时间:pay_time\",\"模板库: 搜索 “订单支付成功通知”，选用类目：软件服务提供商的模板，选用并选择以下参数，提交获得模板ID。\",\"字段名 字段值 字段内容\",\"订单编号 character_string1 {order_sn}\",\"支付时间 time2 {pay_time}\",\"订单金额 amount3 {order_amount}\",\"商品名称 thing4 {goods_name}\",\"配置路径：小程序后台 > 功能 > 订阅消息\"]}', '{\"type\":\"mnp\",\"template_id\":\"WpJfHZNwd2TSjjc4lsb5hc2JR_OPTDQYTplIR53ZAz4\",\"template_sn\":\"\",\"name\":\"\",\"tpl\":[{\"tpl_name\":\"订单编号\",\"tpl_keyword\":\"character_string1\",\"tpl_content\":\"{order_sn}\"},{\"tpl_name\":\"支付时间\",\"tpl_keyword\":\"time2\",\"tpl_content\":\"{pay_time}\"},{\"tpl_name\":\"订单金额\",\"tpl_keyword\":\"amount3\",\"tpl_content\":\"{order_amount}\"},{\"tpl_name\":\"商品名称\",\"tpl_keyword\":\"thing4\",\"tpl_content\":\"{goods_name}\"}],\"status\":\"1\",\"is_show\":true,\"tips\":[\"可选变量 用户昵称:nickname 订单编号:order_sn 支付时间:pay_time\",\"模板库: 搜索 “订单支付成功通知”，选用类目：软件服务提供商的模板，选用并选择以下参数，提交获得模板ID。\",\"字段名 字段值 字段内容\",\"订单编号 character_string1 {order_sn}\",\"支付时间 time2 {pay_time}\",\"订单金额 amount3 {order_amount}\",\"商品名称 thing4 {goods_name}\",\"配置路径：小程序后台 > 功能 > 订阅消息\"]}', '1,2,3,4', NULL);
COMMIT;

-- ----------------------------
-- Table structure for ls_dev_pay
-- ----------------------------
DROP TABLE IF EXISTS `ls_dev_pay`;
CREATE TABLE `ls_dev_pay` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL DEFAULT '' COMMENT '支付名称',
  `pay_way` tinyint(1) NOT NULL COMMENT '支付方式:1-余额支付;2-微信支付;3-支付宝支付;',
  `config` text COMMENT '对应支付配置(json字符串)',
  `image` varchar(255) DEFAULT NULL COMMENT '图标',
  `sort` int(5) DEFAULT '0' COMMENT '排序',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='支付配置表';

-- ----------------------------
-- Records of ls_dev_pay
-- ----------------------------
BEGIN;
INSERT INTO `ls_dev_pay` (`id`, `name`, `pay_way`, `config`, `image`, `sort`) VALUES (1, '微信支付', 2, '{\"apiclient_cert\":\"-----BEGIN CERTIFICATE-----\\nMIID6TCCAtGgAwIBAgIUWR/b7XXXXXXwDQYJKoZIhvcNAQEL\\nBQAwXjELMAkGA1UEBhMCQ04xEzARBgNVBAoTClRlbnBheS5jb20xHTAbBgNVBAsT\\nFFRlbnBheS5jb20gQ0EgQ2VudGVyMRswGQYDVQQDExJUZW5wYXkuY29tIFJvb3Qg\\nQ0EwHhcNMjIxMTA0MDIzOTMzWhcNMjcxMTAzMDIXXXXXQYDVQQDDAox\\nNjM0MjIxMzMzMRswGQYDVQQKDBLlvq7kv6HllYbmiLfns7vnu58xJzAlBgNVBAsM\\nHuW5v+W3nuWlveixoeenkeaKgOaciemZkOWFrOWPuDELMAkGA1UEBgwCQ04xETAP\\nBgNVBAcMCFNoZW5aaGVuMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA\\nyjgJhYkSBqm9NECJgikvKTLMuID0si0yP8lbekV+WXXvmGNWG0jW49Eqpyjpt6da\\n9uAacT6Q/FT0Kf1tfuw+tlINetOgEP/CJG6YnNqgLSxTlWfFCLsd1XTKuxj3Tq8X\\njol1jNv5z/sQfG4QAtUPHAEDZQ9tojfOsxvo2V5qFyvAMt4ufcwjypU7yieDAvho\\nMC4KUJlvWXsJQEAXh/t9PIGTuSWdxn+fEWlMC6+96n6LfaEe0YYknYs/9ataz4Ks\\noCyUUtUea0wTw89bzq0uruwuyWNtjeYJyPTV2iHqUfCRxRiOwoVyetTSnYiorQ5T\\npYBX4Qs4vohoQw0mm6ey1wIDAQABo4GBMH8wCQYDVR0TBAIwADALBgNVHQ8EBAMC\\nA/gwZQYDVR0fBF4wXDBaoFigVoZUaHR0cDovL2V2Y2EuaXRydXMuY29tLmNuL3B1\\nYmxpYy9pdHJ1c2NybD9DQT0xQkQ0MjIwRTUwREJDMDRCMDZBRDM5NzU0OTg0NkMw\\nMUMzRThFQkQyMA0GCSqGSIb3DQEBCwUAA4IBAQCtPFGPYHsTA6m6Wq/0gJecDcyJ\\npVFqtgMMcZPKmofHEYdJq4Ju9Wnn9qCaMlsODK+ZGdjQS/7rUpbCJVVyQG0pb4F5\\np+SuRgaXywwyrv+aO9eNlwGnEBrAOqzUGI/L3rpLzchLIehQ6NRZx9a9wOoGqGJm\\nzpOq+G4ECUsFrKnF5ZvRIwlctDIzkIwwitayLtWzHrEl9aZNPUylzGfwbZR4b9o3\\n/4cr87PLMZ2PUI0agJ3D4viXV/hZrb/eSlsdUXmkww56RX5hYmwC0cdH4aKc9Pdq\\nsVtxN5pQPt/E0JvXg+zoM0R1vY96xiQCxnPwZ3JM99Ze/v3RjsHjTkGzk94+\\n-----END CERTIFICATE-----\",\"apiclient_key\":\"-----BEGIN PRIVATE KEY-----\\nMIIEvAIBADANBgkqhkiG9w0BAQEFAASCBKYwggSiAgEAAoIBAQDKOAmFiRIGqb00\\nQImCKS8pMsy4gPSyLTI/yVt6RX5Zde+YY1YbSNbj0SqnKOm3p1r24BpxPpD8VPQp\\n/W1+7D62Ug1606AQ/8Ikbpic2qAtLFOVZ8UIux3VdMq7GPdOrxeOiXWM2/nP+xB8\\nbhAC1Q8cAQNlD22iN86zG+jZXmoXK8Ay3i59zCPKlTvKJ4MC+GgwLgpQmW9ZewlA\\nQBeH+308gZO5JZ3Gf58RaUwLr73qfot9oR7RhiSdiz/1q1rPgqygLJRS1R5rTBPD\\nz1vOrS6u7C7JY22N5gnI9NXaIepR8JHFGI7ChXJ61NKdiKitXXXXiGhD\\nDSabp7LXAgMBAAECggEAb+9m7eD69m88yVC0DTWo4mA5TCQtzvcPqplWJq+TCggr\\nUSojfsTqFn8w4gjWno9n3eIdIPRmIxcPdLLQyoIRELEIvyWno+E+4RXLKoAmS/sO\\nZVRkj7msAP0+PyTJuGdZXdAfHpKhjIvIC2iNOlQfofu5mlZY9IN5ylE3qiMGDL5y\\nGwgimqdd2tnDZ8EMafuEKjJYuQj4i5MC0BQZsV65derlYtUIPnmisdPiMWMM6sQ+\\nUQzkg0AJDkV8XzKmbsEc4UB+D44+86/axsNZ/bYitFbkse720vfEbn/Fydz+yp+0\\nWpdQcPg5E1xcQEshxQy8Q52zvQfIVhYMYmJ0FVb0QQKBgQDoNb+OGYbhnaqMTNbC\\ndiY7f4CepLJwD/UfOlqbNgkM39nVOw4+lis4c/cfBAyJk8TrWiUqHU+T4hWRhkPZ\\nW+rVObkHiWU8nWZvoGIvI/P4W7Le2v2OIcMBjuQ6i64YSe4kxTCCc+u7dAxpIy1W\\nArDZsPZ41Q82fCI/rfUv8m0EtwKBgQDe77Pzhb2//zSVKCor3rAEwCgN8LG+Dqa3\\n8n9z6YDVHVT6y4Bnp0QczfbtszjiZXc0y5x9qVzqvy6O6/MpoGvUpT2BtRNyxdqH\\nzQk7Bu1J3n4vvUG3IOSXM/kwrGwm8Qk6jGOFWb0MT57Fwyi/DL9mzPFp0/a4ftS1\\nDWDM9rvi4QKBgCHTqpr9tvto525WxzY+1eT29vqlTWUrve6VpptTrM/WUDpSxwlx\\nAMzRf99hzJ3CC/6o/B79dBk75x5y67FfRX9YUE77weapm0GJoKPzXdgBK7ZxOlyZ\\nKHoyoaaxsGPTaUCsBRwL3PxKtIAgYrtT2wVrVQxXJUcvoCGcqsoYS69TAoGANP6w\\nPVRujeSBwG9CzxjpqMdw/hdYeUCMWy/XIlvAl2iYmeGkTX+SjnJbn5e6Dv9lvfQk\\n6C5JezglPi5SqHONDoiVPW8pB2CHGT8hUZnM8IFmZ7zKkVjNXjAprWtfbkZgFj3n\\nLnztlq6apJJG7lt+aFaRkMGlZagosj1S5IZGlaECgYAgFfGJU361lwVuxK8tEEeR\\nnfl+NuvIr5p1PgXXXXXXGpbk6F8Hd3iWqJ0k/rZ9OXoSY/vfSMshD\\ntO2Kls4nQLnv6H3jAlfHt615tIu6g/eWAAdZnGVUTMI+Tfcp3W2rXTzaGrI6IR1s\\nxa/CVRqQzs3AE5u6aGJmdQ==\\n-----END PRIVATE KEY-----\",\"interface_version\":\"v3\",\"mch_id\":\"163XXX333\",\"merchant_type\":\"ordinary_merchant\",\"pay_sign_key\":\"a956fa091XXXXX99a0b661cf5b\"}', '/api/static/wxzf.png', 4);
INSERT INTO `ls_dev_pay` (`id`, `name`, `pay_way`, `config`, `image`, `sort`) VALUES (2, '余额支付', 1, '', '/api/static/yezf.png', 3);
COMMIT;

-- ----------------------------
-- Table structure for ls_dev_pay_way
-- ----------------------------
DROP TABLE IF EXISTS `ls_dev_pay_way`;
CREATE TABLE `ls_dev_pay_way` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `scene` tinyint(1) NOT NULL COMMENT '场景:1-微信小程序;2-微信公众号;3-H5;4-PC商城;5-APP;',
  `pay_id` int(10) NOT NULL COMMENT '支付配置ID',
  `is_default` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否默认支付:0-否;1-是;',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态:0-关闭;1-开启;',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COMMENT='支付方式表';

-- ----------------------------
-- Records of ls_dev_pay_way
-- ----------------------------
BEGIN;
INSERT INTO `ls_dev_pay_way` (`id`, `scene`, `pay_id`, `is_default`, `status`) VALUES (1, 1, 1, 0, 1);
INSERT INTO `ls_dev_pay_way` (`id`, `scene`, `pay_id`, `is_default`, `status`) VALUES (2, 1, 2, 1, 1);
INSERT INTO `ls_dev_pay_way` (`id`, `scene`, `pay_id`, `is_default`, `status`) VALUES (3, 2, 1, 0, 1);
INSERT INTO `ls_dev_pay_way` (`id`, `scene`, `pay_id`, `is_default`, `status`) VALUES (4, 3, 1, 0, 1);
INSERT INTO `ls_dev_pay_way` (`id`, `scene`, `pay_id`, `is_default`, `status`) VALUES (5, 2, 2, 1, 1);
INSERT INTO `ls_dev_pay_way` (`id`, `scene`, `pay_id`, `is_default`, `status`) VALUES (6, 3, 2, 1, 1);
COMMIT;

-- ----------------------------
-- Table structure for ls_dict_data
-- ----------------------------
DROP TABLE IF EXISTS `ls_dict_data`;
CREATE TABLE `ls_dict_data` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `type_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '类型',
  `name` varchar(100) NOT NULL COMMENT '键名',
  `value` varchar(200) NOT NULL COMMENT '数值',
  `remark` varchar(200) NOT NULL COMMENT '备注',
  `sort` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `status` tinyint(1) NOT NULL COMMENT '状态: 0=停用, 1=正常',
  `is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除: 0=否, 1=是',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `delete_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='字典数据表';

-- ----------------------------
-- Records of ls_dict_data
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_dict_type
-- ----------------------------
DROP TABLE IF EXISTS `ls_dict_type`;
CREATE TABLE `ls_dict_type` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `dict_name` varchar(100) NOT NULL DEFAULT '' COMMENT '字典名称',
  `dict_type` varchar(100) NOT NULL DEFAULT '' COMMENT '字典类型',
  `dict_remark` varchar(200) NOT NULL DEFAULT '' COMMENT '字典备注',
  `dict_status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '字典状态: 0=停用, 1=正常',
  `is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除: 0=否, 1=是',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `delete_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='字典类型表';

-- ----------------------------
-- Records of ls_dict_type
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_file
-- ----------------------------
DROP TABLE IF EXISTS `ls_file`;
CREATE TABLE `ls_file` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `cid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '类目ID',
  `source` tinyint(1) NOT NULL DEFAULT '0' COMMENT '类型：0-后台；1-用户',
  `source_id` int(11) NOT NULL COMMENT '来源id',
  `type` tinyint(2) unsigned NOT NULL DEFAULT '10' COMMENT '类型[10=图片, 20=视频]',
  `name` varchar(100) NOT NULL DEFAULT '' COMMENT '文件名称',
  `uri` varchar(200) NOT NULL COMMENT '文件路径',
  `create_time` int(10) unsigned DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(10) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文件表';

-- ----------------------------
-- Records of ls_file
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_file_cate
-- ----------------------------
DROP TABLE IF EXISTS `ls_file_cate`;
CREATE TABLE `ls_file_cate` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父级ID',
  `type` tinyint(2) unsigned NOT NULL DEFAULT '10' COMMENT '类型[10=图片，20=视频，30=文件]',
  `name` varchar(32) NOT NULL DEFAULT '' COMMENT '分类名称',
  `create_time` int(10) unsigned DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) unsigned DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(10) unsigned DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文件分类表';

-- ----------------------------
-- Records of ls_file_cate
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_gen_table
-- ----------------------------
DROP TABLE IF EXISTS `ls_gen_table`;
CREATE TABLE `ls_gen_table` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `table_name` varchar(200) NOT NULL DEFAULT '' COMMENT '表名称',
  `table_comment` varchar(200) NOT NULL DEFAULT '' COMMENT '表描述',
  `sub_table_name` varchar(200) NOT NULL DEFAULT '' COMMENT '关联表名称',
  `sub_table_fk` varchar(200) NOT NULL DEFAULT '' COMMENT '关联表外键',
  `author_name` varchar(100) NOT NULL DEFAULT '' COMMENT '作者的名称',
  `entity_name` varchar(100) NOT NULL DEFAULT '' COMMENT '实体的名称',
  `module_name` varchar(60) NOT NULL DEFAULT '' COMMENT '生成模块名',
  `function_name` varchar(60) NOT NULL DEFAULT '' COMMENT '生成功能名',
  `tree_primary` varchar(60) NOT NULL DEFAULT '' COMMENT '树主键字段',
  `tree_parent` varchar(60) NOT NULL DEFAULT '' COMMENT '树父级字段',
  `tree_name` varchar(60) NOT NULL DEFAULT '' COMMENT '树显示字段',
  `gen_tpl` varchar(20) NOT NULL DEFAULT 'crud' COMMENT '生成模板方式: [crud=单表, tree=树表]',
  `gen_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '生成代码方式: [0=zip压缩包, 1=自定义路径]',
  `gen_path` varchar(200) NOT NULL DEFAULT '/' COMMENT '生成代码路径: [不填默认项目路径]',
  `remarks` varchar(200) NOT NULL DEFAULT '' COMMENT '备注信息',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='代码生成业务表';

-- ----------------------------
-- Records of ls_gen_table
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_gen_table_column
-- ----------------------------
DROP TABLE IF EXISTS `ls_gen_table_column`;
CREATE TABLE `ls_gen_table_column` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '列主键',
  `table_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '表外键',
  `column_name` varchar(200) NOT NULL DEFAULT '' COMMENT '列名称',
  `column_comment` varchar(200) NOT NULL DEFAULT '' COMMENT '列描述',
  `column_length` smallint(5) unsigned DEFAULT '0' COMMENT '列长度',
  `column_type` varchar(100) NOT NULL DEFAULT '' COMMENT '列类型 ',
  `java_type` varchar(100) NOT NULL DEFAULT '' COMMENT 'JAVA类型',
  `java_field` varchar(100) NOT NULL DEFAULT '' COMMENT 'JAVA字段',
  `is_pk` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否主键: [1=是, 0=否]',
  `is_increment` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否自增: [1=是, 0=否]',
  `is_required` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否必填: [1=是, 0=否]',
  `is_insert` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否插入字段: [1=是, 0=否]',
  `is_edit` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否编辑字段: [1=是, 0=否]',
  `is_list` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否列表字段: [1=是, 0=否]',
  `is_query` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否查询字段: [1=是, 0=否]',
  `query_type` varchar(30) NOT NULL DEFAULT 'EQ' COMMENT '查询方式: [等于、不等于、大于、小于、范围]',
  `html_type` varchar(30) NOT NULL DEFAULT '' COMMENT '显示类型: [文本框、文本域、下拉框、复选框、单选框、日期控件]',
  `dict_type` varchar(200) NOT NULL DEFAULT '' COMMENT '字典类型',
  `sort` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '排序编号',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='代码生成字段表';

-- ----------------------------
-- Records of ls_gen_table_column
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_hot_search
-- ----------------------------
DROP TABLE IF EXISTS `ls_hot_search`;
CREATE TABLE `ls_hot_search` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(200) NOT NULL DEFAULT '' COMMENT '关键词',
  `sort` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '排序号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb4 COMMENT='热门搜索配置表';

-- ----------------------------
-- Records of ls_hot_search
-- ----------------------------
BEGIN;
INSERT INTO `ls_hot_search` (`id`, `name`, `sort`) VALUES (47, '后端', 0);
INSERT INTO `ls_hot_search` (`id`, `name`, `sort`) VALUES (48, '前端', 0);
INSERT INTO `ls_hot_search` (`id`, `name`, `sort`) VALUES (49, '33', 3);
INSERT INTO `ls_hot_search` (`id`, `name`, `sort`) VALUES (50, '333', 2);
COMMIT;

-- ----------------------------
-- Table structure for ls_index_visit
-- ----------------------------
DROP TABLE IF EXISTS `ls_index_visit`;
CREATE TABLE `ls_index_visit` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ip` varchar(255) NOT NULL COMMENT '访客ip地址',
  `terminal` tinyint(1) NOT NULL COMMENT '访问终端',
  `visit` int(10) NOT NULL COMMENT '浏览量',
  `create_time` int(10) DEFAULT NULL COMMENT '访问时间',
  `update_time` int(10) DEFAULT NULL,
  `delete_time` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='首页浏览记录表';

-- ----------------------------
-- Records of ls_index_visit
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_menu
-- ----------------------------
DROP TABLE IF EXISTS `ls_menu`;
CREATE TABLE `ls_menu` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL COMMENT '菜单名称',
  `decorate_type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '菜单类型：1-首页导航；2-个人中心',
  `image` varchar(255) DEFAULT NULL COMMENT '菜单图标',
  `link_type` tinyint(1) NOT NULL COMMENT '链接类型：1-商城页面；2-商品分类；3-自定义链接',
  `link_address` varchar(255) NOT NULL COMMENT '链接地址',
  `sort` int(5) DEFAULT '0' COMMENT '菜单排序',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态；1-启用；0-停用',
  `create_time` int(10) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(10) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COMMENT='菜单表';

-- ----------------------------
-- Records of ls_menu
-- ----------------------------
BEGIN;
INSERT INTO `ls_menu` (`id`, `name`, `decorate_type`, `image`, `link_type`, `link_address`, `sort`, `status`, `create_time`, `update_time`, `delete_time`) VALUES (1, '后台开发', 1, 'uploads/images/20220607114507569789177.webp', 1, '1', 50, 1, 1653989998, 1654573525, NULL);
INSERT INTO `ls_menu` (`id`, `name`, `decorate_type`, `image`, `link_type`, `link_address`, `sort`, `status`, `create_time`, `update_time`, `delete_time`) VALUES (2, '前端开发', 1, 'uploads/images/20220607114507db4717303.png', 1, '1', 50, 1, 1654573541, 1654573541, NULL);
INSERT INTO `ls_menu` (`id`, `name`, `decorate_type`, `image`, `link_type`, `link_address`, `sort`, `status`, `create_time`, `update_time`, `delete_time`) VALUES (3, '互联网产品', 1, 'uploads/images/20220607114507d76501834.png', 1, '1', 50, 1, 1654573556, 1654573556, NULL);
INSERT INTO `ls_menu` (`id`, `name`, `decorate_type`, `image`, `link_type`, `link_address`, `sort`, `status`, `create_time`, `update_time`, `delete_time`) VALUES (4, '平面设计', 1, 'uploads/images/202206071145072329a5987.webp', 1, '1', 50, 1, 1654573655, 1654573655, NULL);
INSERT INTO `ls_menu` (`id`, `name`, `decorate_type`, `image`, `link_type`, `link_address`, `sort`, `status`, `create_time`, `update_time`, `delete_time`) VALUES (5, '绘画创作', 1, 'uploads/images/20220607114507763546082.png', 1, '1', 50, 1, 1654573848, 1654573848, NULL);
INSERT INTO `ls_menu` (`id`, `name`, `decorate_type`, `image`, `link_type`, `link_address`, `sort`, `status`, `create_time`, `update_time`, `delete_time`) VALUES (6, '职场英语', 1, 'uploads/images/20220607114507403d24341.webp', 1, '1', 50, 1, 1654573867, 1654573867, NULL);
INSERT INTO `ls_menu` (`id`, `name`, `decorate_type`, `image`, `link_type`, `link_address`, `sort`, `status`, `create_time`, `update_time`, `delete_time`) VALUES (7, '英语口语', 1, 'uploads/images/202206071145077765e3102.webp', 1, '1', 50, 1, 1654583768, 1654583768, NULL);
INSERT INTO `ls_menu` (`id`, `name`, `decorate_type`, `image`, `link_type`, `link_address`, `sort`, `status`, `create_time`, `update_time`, `delete_time`) VALUES (8, '游戏美术设计', 1, 'uploads/images/20220607114507899d67243.webp', 1, '1', 50, 1, 1654583872, 1654583872, NULL);
INSERT INTO `ls_menu` (`id`, `name`, `decorate_type`, `image`, `link_type`, `link_address`, `sort`, `status`, `create_time`, `update_time`, `delete_time`) VALUES (9, '企业购', 1, 'uploads/images/202206071145071166d1552.webp', 1, '1', 50, 1, 1654583887, 1654583887, NULL);
INSERT INTO `ls_menu` (`id`, `name`, `decorate_type`, `image`, `link_type`, `link_address`, `sort`, `status`, `create_time`, `update_time`, `delete_time`) VALUES (10, '全部分类', 1, 'uploads/images/2022060711450729fe07307.webp', 1, '1', 50, 0, 1654583907, 1654590492, NULL);
INSERT INTO `ls_menu` (`id`, `name`, `decorate_type`, `image`, `link_type`, `link_address`, `sort`, `status`, `create_time`, `update_time`, `delete_time`) VALUES (11, 'asad ', 1, 'uploads/images/202206071028003ad754733.png', 1, '1', 50, 0, 1654584923, 1654590471, NULL);
COMMIT;

-- ----------------------------
-- Table structure for ls_notice
-- ----------------------------
DROP TABLE IF EXISTS `ls_notice`;
CREATE TABLE `ls_notice` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `user_id` int(10) unsigned NOT NULL COMMENT '用户id',
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '标题',
  `content` text NOT NULL COMMENT '内容',
  `scene_id` int(10) unsigned DEFAULT '0' COMMENT '场景',
  `read` tinyint(1) DEFAULT '0' COMMENT '已读状态;0-未读,1-已读',
  `recipient` tinyint(1) DEFAULT '0' COMMENT '通知接收对象类型;1-会员;2-商家;3-平台;4-游客(未注册用户)',
  `send_type` tinyint(1) DEFAULT '0' COMMENT '通知发送类型 1-系统通知 2-短信通知 3-微信模板 4-微信小程序',
  `notice_type` tinyint(1) DEFAULT NULL COMMENT '通知类型 1-业务通知 2-验证码',
  `extra` varchar(255) DEFAULT '' COMMENT '其他',
  `create_time` int(10) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(10) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='通知记录表';

-- ----------------------------
-- Records of ls_notice
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_notice_record
-- ----------------------------
DROP TABLE IF EXISTS `ls_notice_record`;
CREATE TABLE `ls_notice_record` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `user_id` int(10) unsigned NOT NULL COMMENT '用户id',
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '标题',
  `content` text NOT NULL COMMENT '内容',
  `scene_id` int(10) unsigned DEFAULT '0' COMMENT '场景',
  `read` tinyint(1) DEFAULT '0' COMMENT '已读状态;0-未读,1-已读',
  `recipient` tinyint(1) DEFAULT '0' COMMENT '通知接收对象类型;1-会员;2-商家;3-平台;4-游客(未注册用户)',
  `send_type` tinyint(1) DEFAULT '0' COMMENT '通知发送类型 1-系统通知 2-短信通知 3-微信模板 4-微信小程序',
  `notice_type` tinyint(1) DEFAULT NULL COMMENT '通知类型 1-业务通知 2-验证码',
  `extra` varchar(255) DEFAULT '' COMMENT '其他',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `delete_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='消息通知记录表';

-- ----------------------------
-- Records of ls_notice_record
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_notice_setting
-- ----------------------------
DROP TABLE IF EXISTS `ls_notice_setting`;
CREATE TABLE `ls_notice_setting` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `scene` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '场景编号',
  `name` varchar(100) NOT NULL DEFAULT '' COMMENT '场景名称',
  `remarks` varchar(200) NOT NULL DEFAULT '' COMMENT '场景描述',
  `recipient` tinyint(1) NOT NULL DEFAULT '1' COMMENT '接收人员: [1=用户, 2=平台]',
  `type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '通知类型: [1=业务, 2=验证]',
  `system_notice` text COMMENT '系统的通知设置',
  `sms_notice` text COMMENT '短信的通知设置',
  `oa_notice` text COMMENT '公众号通知设置',
  `mnp_notice` text COMMENT '小程序通知设置',
  `is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `delete_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='消息通知设置表';

-- ----------------------------
-- Records of ls_notice_setting
-- ----------------------------
BEGIN;
INSERT INTO `ls_notice_setting` (`id`, `scene`, `name`, `remarks`, `recipient`, `type`, `system_notice`, `sms_notice`, `oa_notice`, `mnp_notice`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (1, 101, '登录验证码', '用户手机号码登录时发送', 1, 2, '{}', '{\"type\":\"sms\",\"templateId\":\"SMS_222458159\",\"content\":\"您正在登录，验证码${code}，切勿将验证码泄露于他人，本条验证码有效期5分钟。\",\"tips\":\"[\\\"可选变量 验证码:code\\\",\\\"示例：您正在登录，验证码${code}，切勿将验证码泄露于他人，本条验证码有效期5分钟。\\\",\\\"生效条件：1、管理后台完成短信设置。2、第三方短信平台申请模板。\\\"]\",\"status\":\"1\"}', '{\"tpl\":\"\\\"null\\\"\",\"name\":\"\"}', '{}', 0, 1648696695, 1671531745, 0);
INSERT INTO `ls_notice_setting` (`id`, `scene`, `name`, `remarks`, `recipient`, `type`, `system_notice`, `sms_notice`, `oa_notice`, `mnp_notice`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (2, 102, '绑定手机验证码', '用户绑定手机号码时发送', 1, 2, '{}', '{\"type\":\"sms\",\"templateId\":\"SMS_175615069\",\"content\":\"您正在绑定手机号，验证码${code}，切勿将验证码泄露于他人，本条验证码有效期5分钟。\",\"tips\":[\"可选变量 验证码:code\",\"示例：您正在绑定手机号，验证码${code}，切勿将验证码泄露于他人，本条验证码有效期5分钟。\",\"生效条件：1、管理后台完成短信设置。2、第三方短信平台申请模板。\"],\"status\":\"1\"}', '{}', '{}', 0, 1648696695, 1648696695, 0);
INSERT INTO `ls_notice_setting` (`id`, `scene`, `name`, `remarks`, `recipient`, `type`, `system_notice`, `sms_notice`, `oa_notice`, `mnp_notice`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (3, 103, '变更手机验证码', '用户变更手机号码时发送', 1, 2, '{}', '{\"type\":\"sms\",\"templateId\":\"SMS_207952628\",\"content\":\"您正在变更手机号，验证码${code}，切勿将验证码泄露于他人，本条验证码有效期5分钟。\",\"tips\":[\"可选变量 验证码:code\",\"示例：您正在变更手机号，验证码${code}，切勿将验证码泄露于他人，本条验证码有效期5分钟。\",\"生效条件：1、管理后台完成短信设置。2、第三方短信平台申请模板。\"],\"status\":\"1\"}', '{}', '{}', 0, 1648696695, 1648696695, 0);
INSERT INTO `ls_notice_setting` (`id`, `scene`, `name`, `remarks`, `recipient`, `type`, `system_notice`, `sms_notice`, `oa_notice`, `mnp_notice`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (4, 104, '找回登录密码验证码', '用户找回登录密码号码时发送', 1, 2, '{}', '{\"type\":\"sms\",\"templateId\":\"SMS_175615069\",\"content\":\"您正在找回登录密码，验证码${code}，切勿将验证码泄露于他人，本条验证码有效期5分钟。\",\"tips\":[\"可选变量 验证码:code\",\"示例：您正在找回登录密码，验证码${code}，切勿将验证码泄露于他人，本条验证码有效期5分钟。\",\"条验证码有效期5分钟。\"],\"status\":\"1\"}', '{}', '{}', 0, 1648696695, 1648696695, 0);
COMMIT;

-- ----------------------------
-- Table structure for ls_official_account_reply
-- ----------------------------
DROP TABLE IF EXISTS `ls_official_account_reply`;
CREATE TABLE `ls_official_account_reply` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL DEFAULT '' COMMENT '规则名称',
  `keyword` varchar(64) NOT NULL DEFAULT '' COMMENT '关键词',
  `reply_type` tinyint(1) NOT NULL COMMENT '回复类型 1-关注回复 2-关键字回复 3-默认回复',
  `matching_type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '匹配方式：1-全匹配；2-模糊匹配',
  `content_type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '内容类型：1-文本',
  `content` text NOT NULL COMMENT '回复内容',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '启动状态：1-启动；0-关闭',
  `sort` int(10) unsigned NOT NULL DEFAULT '50' COMMENT '排序',
  `create_time` int(10) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(10) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='微信公众号自动回复表';

-- ----------------------------
-- Records of ls_official_account_reply
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_official_reply
-- ----------------------------
DROP TABLE IF EXISTS `ls_official_reply`;
CREATE TABLE `ls_official_reply` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(64) NOT NULL DEFAULT '' COMMENT '规则名',
  `keyword` varchar(64) NOT NULL DEFAULT '' COMMENT '关键词',
  `reply_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '回复类型: [1=关注回复 2=关键字回复, 3=默认回复]',
  `matching_type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '匹配方式: [1=全匹配, 2=模糊匹配]',
  `content_type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '内容类型: [1=文本]',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '启动状态: [1=启动, 0=关闭]',
  `content` text NOT NULL COMMENT '回复内容',
  `sort` int(11) unsigned NOT NULL DEFAULT '50' COMMENT '排序编号',
  `is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除',
  `create_time` int(10) unsigned DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned DEFAULT '0' COMMENT '更新时间',
  `delete_time` int(10) unsigned DEFAULT '0' COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='公众号的回复表';

-- ----------------------------
-- Records of ls_official_reply
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_operation_log
-- ----------------------------
DROP TABLE IF EXISTS `ls_operation_log`;
CREATE TABLE `ls_operation_log` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `admin_id` int(10) NOT NULL COMMENT '管理员ID',
  `admin_name` varchar(16) NOT NULL DEFAULT '' COMMENT '管理员名称',
  `account` varchar(16) NOT NULL DEFAULT '' COMMENT '管理员账号',
  `action` varchar(64) DEFAULT '' COMMENT '操作名称',
  `type` varchar(8) NOT NULL COMMENT '请求方式',
  `url` varchar(255) NOT NULL COMMENT '访问链接',
  `params` text COMMENT '请求数据',
  `result` text COMMENT '请求结果',
  `ip` varchar(15) NOT NULL DEFAULT '' COMMENT 'ip地址',
  `create_time` int(10) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统日志表';

-- ----------------------------
-- Records of ls_operation_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_order
-- ----------------------------
DROP TABLE IF EXISTS `ls_order`;
CREATE TABLE `ls_order` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `sn` varchar(64) NOT NULL COMMENT '订单编号',
  `transaction_id` varchar(128) DEFAULT NULL COMMENT '第三方交易号',
  `user_id` int(10) NOT NULL COMMENT '用户id',
  `order_terminal` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '订单来源;1-微信小程序;2-微信公众号;3-手机H5;4-PC;5-苹果app;6-安卓app;',
  `order_status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '订单状态;1-待付款;2已完成;3-已关闭',
  `pay_status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '支付状态;0-待支付;1-已支付;',
  `pay_way` tinyint(2) NOT NULL DEFAULT '0' COMMENT '支付方式:1-余额支付;2-微信支付;3-支付宝支付;',
  `pay_time` int(10) unsigned DEFAULT '0' COMMENT '支付时间',
  `total_amount` decimal(10,2) DEFAULT '0.00' COMMENT '订单总价',
  `order_amount` decimal(10,2) DEFAULT '0.00' COMMENT '应付款金额',
  `coupon_discount_price` decimal(10,2) DEFAULT NULL COMMENT '优惠券优惠金额',
  `integral_discount_price` decimal(10,2) DEFAULT NULL COMMENT '积分优惠的价格',
  `integral_val` decimal(10,2) DEFAULT NULL COMMENT '抵扣的积分',
  `refund_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '退款状态：1-未退款；2-部分退款；3-全部退款',
  `cancel_time` int(11) DEFAULT NULL COMMENT '取消订单时间',
  `refund_time` int(11) DEFAULT NULL COMMENT '退款时间',
  `shop_remark` varchar(64) DEFAULT NULL COMMENT '商家备注',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) NOT NULL COMMENT '更新时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=798 DEFAULT CHARSET=utf8mb4 COMMENT='订单表';

-- ----------------------------
-- Records of ls_order
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_order_course
-- ----------------------------
DROP TABLE IF EXISTS `ls_order_course`;
CREATE TABLE `ls_order_course` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `order_id` int(10) NOT NULL COMMENT '订单id',
  `course_id` int(10) NOT NULL COMMENT '课程id',
  `course_snap` text COMMENT '课程快照',
  `is_comment` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否已评价：1-是；0-否',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='订单课程表';

-- ----------------------------
-- Records of ls_order_course
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_order_log
-- ----------------------------
DROP TABLE IF EXISTS `ls_order_log`;
CREATE TABLE `ls_order_log` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '类型 1-系统 2-卖家 3-买家',
  `channel` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '渠道编号。变动方式。',
  `order_id` int(10) NOT NULL DEFAULT '0' COMMENT '订单id',
  `operator_id` int(10) NOT NULL DEFAULT '0' COMMENT '操作人id',
  `content` varchar(255) DEFAULT '' COMMENT '日志内容',
  `create_time` int(10) unsigned DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) unsigned DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='订单日志表';

-- ----------------------------
-- Records of ls_order_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_order_refund
-- ----------------------------
DROP TABLE IF EXISTS `ls_order_refund`;
CREATE TABLE `ls_order_refund` (
  `id` int(6) unsigned NOT NULL AUTO_INCREMENT,
  `sn` varchar(32) NOT NULL DEFAULT '' COMMENT '退款单号',
  `order_id` int(10) unsigned DEFAULT '0' COMMENT '订单id',
  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '下单用户id，冗余字段',
  `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '类型:1-系统;2-后台;3-用户;',
  `order_terminal` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '订单来源;1-微信小程序;2-微信公众号;3-手机H5;4-PC;5-苹果app;6-安卓app;',
  `transaction_id` varchar(40) DEFAULT NULL COMMENT '第三方平台交易流水号',
  `order_amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '订单总的应付款金额，冗余字段',
  `refund_amount` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '本次退款金额',
  `refund_status` tinyint(1) unsigned DEFAULT '0' COMMENT '退款申请状态:0-退款中;1-退款成功;2-退款失败;',
  `create_time` int(10) unsigned DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) unsigned DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='订单退款表';

-- ----------------------------
-- Records of ls_order_refund
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_order_refund_log
-- ----------------------------
DROP TABLE IF EXISTS `ls_order_refund_log`;
CREATE TABLE `ls_order_refund_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sn` varchar(32) NOT NULL COMMENT '退款单号',
  `refund_id` int(11) NOT NULL COMMENT '退款表id',
  `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '类型:1-系统;2-后台;3-用户;',
  `operator_id` int(10) NOT NULL DEFAULT '0' COMMENT '操作人id',
  `refund_status` tinyint(1) unsigned DEFAULT '0' COMMENT '退款申请状态:0-退款中;1-退款成功;2-退款失败;',
  `wechat_refund_id` varchar(30) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '微信返回退款id',
  `refund_msg` text CHARACTER SET utf8mb4 COMMENT '返回信息',
  `create_time` int(10) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) unsigned DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单退款日志表';

-- ----------------------------
-- Records of ls_order_refund_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_points_log
-- ----------------------------
DROP TABLE IF EXISTS `ls_points_log`;
CREATE TABLE `ls_points_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL COMMENT '会员id',
  `owner_id` int(10) DEFAULT NULL,
  `change_type` smallint(5) NOT NULL COMMENT '变动类型',
  `action` tinyint(1) NOT NULL DEFAULT '0' COMMENT '动作:1-增加；0-减少',
  `change_points` decimal(10,0) NOT NULL COMMENT '变动数量',
  `changeless_points` decimal(10,2) DEFAULT NULL COMMENT '固定数量',
  `additional_points` decimal(10,2) DEFAULT NULL COMMENT '额外数量',
  `left_points` decimal(10,2) NOT NULL DEFAULT '100.00' COMMENT '变动后数量',
  `remark` varchar(255) DEFAULT '' COMMENT '备注',
  `feature` text COMMENT '预留扩展字段',
  `association_sn` varchar(255) DEFAULT NULL,
  `create_time` int(10) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(10) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of ls_points_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_recharge_order
-- ----------------------------
DROP TABLE IF EXISTS `ls_recharge_order`;
CREATE TABLE `ls_recharge_order` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `sn` varchar(64) NOT NULL COMMENT '订单编号',
  `user_id` int(10) NOT NULL COMMENT '用户id',
  `transaction_id` varchar(128) DEFAULT NULL COMMENT '第三方平台交易流水号',
  `terminal` tinyint(1) DEFAULT '1' COMMENT '终端',
  `pay_way` tinyint(2) NOT NULL DEFAULT '1' COMMENT '支付方式',
  `pay_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '支付状态：0-待支付；1-已支付',
  `pay_time` int(10) DEFAULT NULL COMMENT '支付时间',
  `template_id` int(10) DEFAULT NULL COMMENT '模板id',
  `order_amount` decimal(10,2) NOT NULL COMMENT '充值金额',
  `award` text COMMENT '充值奖励',
  `create_time` int(10) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(10) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='充值订单表';

-- ----------------------------
-- Records of ls_recharge_order
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_recharge_template
-- ----------------------------
DROP TABLE IF EXISTS `ls_recharge_template`;
CREATE TABLE `ls_recharge_template` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `money` decimal(10,2) NOT NULL COMMENT '充值金额',
  `award` text COMMENT '充值奖励',
  `sort` int(10) DEFAULT NULL COMMENT '排序',
  `is_recommend` tinyint(1) unsigned DEFAULT '0' COMMENT '是否推荐：1-是；0-否',
  `create_time` int(10) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(10) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='充值模板表';

-- ----------------------------
-- Records of ls_recharge_template
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_refund
-- ----------------------------
DROP TABLE IF EXISTS `ls_refund`;
CREATE TABLE `ls_refund` (
  `id` int(6) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `sn` varchar(32) NOT NULL DEFAULT '' COMMENT '退款单号',
  `order_id` int(10) unsigned DEFAULT '0' COMMENT '订单id',
  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '下单用户id，冗余字段',
  `order_amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '订单总的应付款金额，冗余字段',
  `refund_amount` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '本次退款金额',
  `transaction_id` varchar(100) DEFAULT NULL COMMENT '第三方平台交易流水号',
  `refund_status` tinyint(1) unsigned DEFAULT '1' COMMENT '退款申请状态：1-退款中，1-退款失败，2-退款成功',
  `refund_time` int(1) unsigned DEFAULT NULL COMMENT '退款时间',
  `wechat_refund_id` varchar(30) DEFAULT NULL COMMENT '微信返回退款id',
  `refund_msg` text COMMENT '微信返回信息',
  `create_time` int(10) unsigned DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='退款记录表';

-- ----------------------------
-- Records of ls_refund
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_role
-- ----------------------------
DROP TABLE IF EXISTS `ls_role`;
CREATE TABLE `ls_role` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(16) NOT NULL DEFAULT '' COMMENT '名称',
  `desc` varchar(128) NOT NULL DEFAULT '' COMMENT '描述',
  `create_time` int(10) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(10) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色表';

-- ----------------------------
-- Records of ls_role
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_role_auth_index
-- ----------------------------
DROP TABLE IF EXISTS `ls_role_auth_index`;
CREATE TABLE `ls_role_auth_index` (
  `role_id` int(10) NOT NULL COMMENT '菜单权限ID',
  `auth_key` varchar(64) NOT NULL COMMENT '权限key',
  UNIQUE KEY `unique` (`role_id`,`auth_key`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色与权限关系表';

-- ----------------------------
-- Records of ls_role_auth_index
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_study_course
-- ----------------------------
DROP TABLE IF EXISTS `ls_study_course`;
CREATE TABLE `ls_study_course` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) NOT NULL COMMENT '用户id',
  `course_id` int(10) NOT NULL COMMENT '课程id',
  `source_id` int(10) NOT NULL DEFAULT '0' COMMENT '来源订单',
  `status` tinyint(1) DEFAULT '2' COMMENT '1：未开始；2:学习中；3:学习完成',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) NOT NULL COMMENT '更新时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='课程学习表';

-- ----------------------------
-- Records of ls_study_course
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_study_course_catalogue
-- ----------------------------
DROP TABLE IF EXISTS `ls_study_course_catalogue`;
CREATE TABLE `ls_study_course_catalogue` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) NOT NULL COMMENT '用户id',
  `course_id` int(10) NOT NULL COMMENT '课程id',
  `catalogue_id` int(10) NOT NULL COMMENT '目录id',
  `duration` int(11) DEFAULT NULL COMMENT '用户当前学习的时长',
  `status` tinyint(1) DEFAULT NULL COMMENT '状态：1:未开始；2:进行中；3:完成',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='目录学习记录表';

-- ----------------------------
-- Records of ls_study_course_catalogue
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_subject
-- ----------------------------
DROP TABLE IF EXISTS `ls_subject`;
CREATE TABLE `ls_subject` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(32) NOT NULL COMMENT '专区名称',
  `cover` varchar(128) NOT NULL COMMENT '封面',
  `image` varchar(128) DEFAULT NULL COMMENT '头图',
  `sort` int(10) NOT NULL DEFAULT '0' COMMENT '排序',
  `status` tinyint(1) NOT NULL COMMENT '状态：1-启动；0-关闭',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='专题专区表';

-- ----------------------------
-- Records of ls_subject
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_subject_course
-- ----------------------------
DROP TABLE IF EXISTS `ls_subject_course`;
CREATE TABLE `ls_subject_course` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `subject_id` int(10) NOT NULL COMMENT '专题id',
  `course_id` int(10) NOT NULL COMMENT '课程id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='专题专区课程表';

-- ----------------------------
-- Records of ls_subject_course
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_system_auth_admin
-- ----------------------------
DROP TABLE IF EXISTS `ls_system_auth_admin`;
CREATE TABLE `ls_system_auth_admin` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `dept_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '部门ID',
  `post_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '岗位ID',
  `username` varchar(32) NOT NULL DEFAULT '' COMMENT '用户账号',
  `nickname` varchar(32) NOT NULL DEFAULT '' COMMENT '用户昵称',
  `password` varchar(200) NOT NULL DEFAULT '' COMMENT '用户密码',
  `avatar` varchar(200) NOT NULL DEFAULT '' COMMENT '用户头像',
  `role` varchar(200) NOT NULL DEFAULT '' COMMENT '角色主键',
  `salt` varchar(20) NOT NULL DEFAULT '' COMMENT '加密盐巴',
  `sort` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '排序编号',
  `is_multipoint` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '多端登录: 0=否, 1=是',
  `is_disable` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否禁用: 0=否, 1=是',
  `is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除: 0=否, 1=是',
  `last_login_ip` varchar(20) NOT NULL DEFAULT '' COMMENT '最后登录IP',
  `last_login_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后登录',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `delete_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='系统管理成员表';

-- ----------------------------
-- Records of ls_system_auth_admin
-- ----------------------------
BEGIN;
INSERT INTO `ls_system_auth_admin` (`id`, `dept_id`, `post_id`, `username`, `nickname`, `password`, `avatar`, `role`, `salt`, `sort`, `is_multipoint`, `is_disable`, `is_delete`, `last_login_ip`, `last_login_time`, `create_time`, `update_time`, `delete_time`) VALUES (1, 1, 0, 'admin', 'admin', 'b518f948827909e92b90d1da707d8e8e', '/api/static/backend_avatar.png', '0', 'YjYQ5', 0, 1, 0, 0, '116.16.157.160', 1672397209, 1642321599, 1671532146, 0);
INSERT INTO `ls_system_auth_admin` (`id`, `dept_id`, `post_id`, `username`, `nickname`, `password`, `avatar`, `role`, `salt`, `sort`, `is_multipoint`, `is_disable`, `is_delete`, `last_login_ip`, `last_login_time`, `create_time`, `update_time`, `delete_time`) VALUES (2, 0, 0, 'admin123', 'admin123', '4dc3fcdc90e68d321787602b1f0b23ac', 'image/20221104/564a5da3-7936-41cd-a886-c2fb41bc5afe.png', '1', 'SFMdB', 0, 1, 0, 0, '58.62.164.36', 1667984800, 1667984712, 1667984769, 0);
INSERT INTO `ls_system_auth_admin` (`id`, `dept_id`, `post_id`, `username`, `nickname`, `password`, `avatar`, `role`, `salt`, `sort`, `is_multipoint`, `is_disable`, `is_delete`, `last_login_ip`, `last_login_time`, `create_time`, `update_time`, `delete_time`) VALUES (3, 0, 0, '123', '123', '9042615c6a7e5449129b3a1cfdf5ea2e', '/api/static/backend_avatar.png', '1', 'Rj0C0', 0, 1, 0, 0, '', 0, 1670317477, 1670317477, 0);
INSERT INTO `ls_system_auth_admin` (`id`, `dept_id`, `post_id`, `username`, `nickname`, `password`, `avatar`, `role`, `salt`, `sort`, `is_multipoint`, `is_disable`, `is_delete`, `last_login_ip`, `last_login_time`, `create_time`, `update_time`, `delete_time`) VALUES (4, 0, 0, 'admin321', '1234', 'ffd79915d19c80ddb9c172abdb27dcb1', '/api/static/backend_avatar.png', '2', 'LRr6j', 0, 1, 0, 0, '113.67.10.51', 1671155358, 1671155322, 1671155322, 0);
COMMIT;

-- ----------------------------
-- Table structure for ls_system_auth_dept
-- ----------------------------
DROP TABLE IF EXISTS `ls_system_auth_dept`;
CREATE TABLE `ls_system_auth_dept` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上级主键',
  `name` varchar(100) NOT NULL DEFAULT '' COMMENT '部门名称',
  `duty` varchar(30) NOT NULL DEFAULT '' COMMENT '负责人名',
  `mobile` varchar(30) NOT NULL DEFAULT '' COMMENT '联系电话',
  `sort` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '排序编号',
  `is_stop` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否禁用: 0=否, 1=是',
  `is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除: 0=否, 1=是',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `delete_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COMMENT='系统部门管理表';

-- ----------------------------
-- Records of ls_system_auth_dept
-- ----------------------------
BEGIN;
INSERT INTO `ls_system_auth_dept` (`id`, `pid`, `name`, `duty`, `mobile`, `sort`, `is_stop`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (1, 0, '默认部门', '康明', '18327647788', 10, 0, 0, 1649841995, 1660190949, 0);
INSERT INTO `ls_system_auth_dept` (`id`, `pid`, `name`, `duty`, `mobile`, `sort`, `is_stop`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (2, 1, '研发部', '潘wl', '18688025344', 1, 0, 1, 1665478555, 1665478555, 1665478603);
INSERT INTO `ls_system_auth_dept` (`id`, `pid`, `name`, `duty`, `mobile`, `sort`, `is_stop`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (3, 1, '研发部', '潘wl', '18688925344', 2, 0, 1, 1665478593, 1665480135, 1670314909);
INSERT INTO `ls_system_auth_dept` (`id`, `pid`, `name`, `duty`, `mobile`, `sort`, `is_stop`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (4, 1, '测试部', '潘wl', '18688023233', 2, 0, 0, 1665479293, 1665479973, 0);
INSERT INTO `ls_system_auth_dept` (`id`, `pid`, `name`, `duty`, `mobile`, `sort`, `is_stop`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (5, 4, '222', '222', '15077331753', 0, 0, 1, 1670314965, 1670314965, 1670314969);
INSERT INTO `ls_system_auth_dept` (`id`, `pid`, `name`, `duty`, `mobile`, `sort`, `is_stop`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (6, 4, '3424', '24342', '15077331753', 0, 1, 0, 1670315011, 1670315019, 0);
COMMIT;

-- ----------------------------
-- Table structure for ls_system_auth_menu
-- ----------------------------
DROP TABLE IF EXISTS `ls_system_auth_menu`;
CREATE TABLE `ls_system_auth_menu` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上级菜单',
  `menu_type` char(2) NOT NULL DEFAULT '' COMMENT '权限类型: M=目录，C=菜单，A=按钮',
  `menu_name` varchar(100) NOT NULL DEFAULT '' COMMENT '菜单名称',
  `menu_icon` varchar(100) NOT NULL DEFAULT '' COMMENT '菜单图标',
  `menu_sort` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '菜单排序',
  `perms` varchar(100) NOT NULL DEFAULT '' COMMENT '权限标识',
  `paths` varchar(100) NOT NULL DEFAULT '' COMMENT '路由地址',
  `component` varchar(200) NOT NULL DEFAULT '' COMMENT '前端组件',
  `selected` varchar(200) NOT NULL DEFAULT '' COMMENT '选中路径',
  `params` varchar(200) NOT NULL DEFAULT '' COMMENT '路由参数',
  `is_cache` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否缓存: 0=否, 1=是',
  `is_show` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否显示: 0=否, 1=是',
  `is_disable` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否禁用: 0=否, 1=是',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=875 DEFAULT CHARSET=utf8mb4 COMMENT='系统菜单管理表';

-- ----------------------------
-- Records of ls_system_auth_menu
-- ----------------------------
BEGIN;
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (1, 0, 'C', '工作台', 'el-icon-Monitor', 100, 'common:index:console', 'workbench', 'workbench/index', '', '', 1, 1, 0, 1650341765, 1667371830);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (100, 0, 'M', '权限管理', 'el-icon-Lock', 44, '', 'permission', '', '', '', 0, 1, 0, 1650341765, 1662626201);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (101, 100, 'C', '管理员', 'local-icon-wode', 0, 'system:admin:list', 'admin', 'permission/admin/index', '', '', 1, 1, 0, 1650341765, 1663301404);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (102, 101, 'A', '管理员详情', '', 0, 'system:admin:detail', '', '', '', '', 0, 1, 0, 1650341765, 1660201785);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (103, 101, 'A', '管理员新增', '', 0, 'system:admin:add', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (104, 101, 'A', '管理员编辑', '', 0, 'system:admin:edit', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (105, 101, 'A', '管理员删除', '', 0, 'system:admin:del', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (106, 101, 'A', '管理员状态', '', 0, 'system:admin:disable', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (110, 100, 'C', '角色管理', 'el-icon-Female', 0, 'system:role:list', 'role', 'permission/role/index', '', '', 1, 1, 0, 1650341765, 1663301451);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (111, 110, 'A', '角色详情', '', 0, 'system:role:detail', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (112, 110, 'A', '角色新增', '', 0, 'system:role:add', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (113, 110, 'A', '角色编辑', '', 0, 'system:role:edit', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (114, 110, 'A', '角色删除', '', 0, 'system:role:del', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (120, 100, 'C', '菜单管理', 'el-icon-Operation', 0, 'system:menu:list', 'menu', 'permission/menu/index', '', '', 1, 1, 0, 1650341765, 1663301388);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (121, 120, 'A', '菜单详情', '', 0, 'system:menu:detail', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (122, 120, 'A', '菜单新增', '', 0, 'system:menu:add', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (123, 120, 'A', '菜单编辑', '', 0, 'system:menu:edit', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (124, 120, 'A', '菜单删除', '', 0, 'system:menu:del', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (130, 0, 'M', '组织管理', 'el-icon-OfficeBuilding', 45, '', 'organization', '', '', '', 0, 1, 0, 1650341765, 1664416715);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (131, 130, 'C', '部门管理', 'el-icon-Coordinate', 0, 'system:dept:list', 'department', 'organization/department/index', '', '', 1, 1, 0, 1650341765, 1660201994);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (132, 131, 'A', '部门详情', '', 0, 'system:dept:detail', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (133, 131, 'A', '部门新增', '', 0, 'system:dept:add', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (134, 131, 'A', '部门编辑', '', 0, 'system:dept:edit', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (135, 131, 'A', '部门删除', '', 0, 'system:dept:del', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (140, 130, 'C', '岗位管理', 'el-icon-PriceTag', 0, 'system:post:list', 'post', 'organization/post/index', '', '', 1, 1, 0, 1650341765, 1660202057);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (141, 140, 'A', '岗位详情', '', 0, 'system:post:detail', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (142, 140, 'A', '岗位新增', '', 0, 'system:post:add', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (143, 140, 'A', '岗位编辑', '', 0, 'system:post:edit', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (144, 140, 'A', '岗位删除', '', 0, 'system:post:del', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (200, 0, 'M', '其它管理', '', 0, '', 'null', '', '', '', 0, 0, 0, 1650341765, 1660636870);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (201, 200, 'M', '图库管理', '', 0, '', '', '', '', '', 0, 0, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (202, 201, 'A', '文件列表', '', 0, 'common:album:albumList', '', '', '', '', 0, 0, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (203, 201, 'A', '文件命名', '', 0, 'common:album:albumRename', '', '', '', '', 0, 0, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (204, 201, 'A', '文件移动', '', 0, 'common:album:albumMove', '', '', '', '', 0, 0, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (205, 201, 'A', '文件删除', '', 0, 'common:album:albumDel', '', '', '', '', 0, 0, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (206, 201, 'A', '分类列表', '', 0, 'common:album:cateList', '', '', '', '', 0, 0, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (207, 201, 'A', '分类新增', '', 0, 'common:album:cateAdd', '', '', '', '', 0, 0, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (208, 201, 'A', '分类命名', '', 0, 'common:album:cateRename', '', '', '', '', 0, 0, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (209, 201, 'A', '分类删除', '', 0, 'common:album:cateDel', '', '', '', '', 0, 0, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (215, 200, 'M', '上传管理', '', 0, '', '', '', '', '', 0, 0, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (216, 215, 'A', '上传图片', '', 0, 'common:upload:image', '', '', '', '', 0, 0, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (217, 215, 'A', '上传视频', '', 0, 'common:upload:video', '', '', '', '', 0, 0, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (500, 0, 'M', '系统设置', 'el-icon-Setting', 0, '', 'setting', '', '', '', 0, 1, 0, 1650341765, 1662626322);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (501, 500, 'M', '网站设置', '', 10, '', 'website', '', '', '', 0, 1, 0, 1650341765, 1675759076);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (502, 501, 'C', '网站信息', '', 0, 'setting:website:detail', 'information', 'setting/website/information', '', '', 0, 1, 0, 1650341765, 1660202218);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (503, 502, 'A', '保存配置', '', 0, 'setting:website:save', '', '', '', '', 0, 0, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (505, 501, 'C', '网站备案', '', 0, 'setting:copyright:detail', 'filing', 'setting/website/filing', '', '', 0, 1, 0, 1650341765, 1660202294);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (506, 505, 'A', '备案保存', '', 0, 'setting:copyright:save', '', 'setting/website/protocol', '', '', 0, 0, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (510, 501, 'C', '政策协议', '', 0, 'setting:protocol:detail', 'protocol', 'setting/website/protocol', '', '', 0, 1, 0, 1660027606, 1660202312);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (511, 510, 'A', '协议保存', '', 0, 'setting:protocol:save', '', '', '', '', 0, 0, 0, 1660027606, 1663670865);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (515, 600, 'C', '字典管理', 'el-icon-Box', 0, 'setting:dict:type:list', 'dict', 'setting/dict/type/index', '', '', 0, 1, 0, 1660035436, 1663226087);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (516, 515, 'A', '字典类型新增', '', 0, 'setting:dict:type:add', '', '', '', '', 0, 1, 0, 1660202761, 1660202761);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (517, 515, 'A', '字典类型编辑', '', 0, 'setting:dict:type:edit', '', '', '', '', 0, 1, 0, 1660202842, 1660202842);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (518, 515, 'A', '字典类型删除', '', 0, 'setting:dict:type:del', '', '', '', '', 0, 1, 0, 1660202903, 1660202903);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (519, 600, 'C', '字典数据管理', '', 0, 'setting:dict:data:list', 'dict/data', 'setting/dict/data/index', '/dev_tools/dict', '', 0, 0, 0, 1660202948, 1663309252);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (520, 515, 'A', '字典数据新增', '', 0, 'setting:dict:data:add', '', '', '', '', 0, 1, 0, 1660203117, 1660203117);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (521, 515, 'A', '字典数据编辑', '', 0, 'setting:dict:data:edit', '', '', '', '', 0, 1, 0, 1660203142, 1660203142);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (522, 515, 'A', '字典数据删除', '', 0, 'setting:dict:data:del', '', '', '', '', 0, 1, 0, 1660203159, 1660203159);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (550, 500, 'M', '系统维护', '', 0, '', 'system', '', '', '', 0, 1, 0, 1650341765, 1675759047);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (551, 550, 'C', '系统环境', '', 0, 'monitor:server', 'environment', 'setting/system/environment', '', '', 0, 1, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (552, 550, 'C', '系统缓存', '', 0, 'monitor:cache', 'cache', 'setting/system/cache', '', '', 0, 1, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (553, 550, 'C', '系统日志', '', 0, 'system:log:operate', 'journal', 'setting/system/journal', '', '', 0, 1, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (555, 500, 'C', '存储设置', '', 6, 'setting:storage:list', 'storage', 'setting/storage/index', '', '', 0, 1, 0, 1650341765, 1675759052);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (556, 555, 'A', '保存配置', '', 0, 'setting:storage:edit', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (600, 0, 'M', '开发工具', 'el-icon-EditPen', 0, '', 'dev_tools', '', '', '', 0, 1, 0, 1660027606, 1664335701);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (610, 600, 'C', '代码生成器', 'el-icon-DocumentAdd', 0, 'gen:list', 'code', 'dev_tools/code/index', '', '', 0, 1, 0, 1660028954, 1660532510);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (611, 610, 'A', '导入数据表', '', 0, 'gen:importTable', '', '', '', '', 0, 1, 0, 1660532389, 1660532389);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (612, 610, 'A', '生成代码', '', 0, 'gen:genCode', '', '', '', '', 0, 1, 0, 1660532421, 1660532421);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (613, 610, 'A', '下载代码', '', 0, 'gen:downloadCode', '', '', '', '', 0, 1, 0, 1660532437, 1660532437);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (614, 610, 'A', '预览代码', '', 0, 'gen:previewCode', '', '', '', '', 0, 1, 0, 1660532549, 1660532549);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (616, 610, 'A', '同步表结构', '', 0, 'gen:syncTable', '', '', '', '', 0, 1, 0, 1660532781, 1660532781);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (617, 610, 'A', '删除数据表', '', 0, 'gen:delTable', '', '', '', '', 0, 1, 0, 1660532800, 1660532800);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (618, 610, 'A', '数据表详情', '', 0, 'gen:detail', '', '', '', '', 0, 1, 0, 1660532964, 1660532977);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (700, 0, 'M', '素材管理', 'el-icon-Picture', 43, '', 'material', '', '', '', 0, 0, 0, 1660203293, 1681271534);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (701, 717, 'C', '素材中心', 'el-icon-PictureRounded', 0, '', 'index', 'material/index', '', '', 0, 1, 0, 1660203402, 1681271525);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (706, 0, 'M', '渠道设置', 'el-icon-Message', 46, '', 'channel', '', '', '', 0, 1, 0, 1661767630, 1664416682);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (707, 706, 'C', 'H5设置', 'el-icon-Cellphone', 0, 'channel:h5:detail', 'h5', 'channel/h5', '', '', 0, 1, 0, 1661768566, 1662626123);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (708, 706, 'M', '微信公众号', 'local-icon-dingdan', 0, '', 'wx_oa', '', '', '', 0, 1, 0, 1661769386, 1663301237);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (709, 708, 'C', '公众号配置', '', 0, 'channel:oa:detail', 'config', 'channel/wx_oa/config', '', '', 0, 1, 0, 1661769457, 1662638440);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (710, 706, 'C', '微信小程序', 'local-icon-weixin', 0, 'channel:mp:detail', 'weapp', 'channel/weapp', '', '', 0, 1, 0, 1661823746, 1663301266);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (711, 706, 'C', '微信开发平台', 'el-icon-DataBoard', 0, 'channel:wx:detail', 'wx_dev', 'channel/wx_dev', '', '', 0, 0, 0, 1661824989, 1663310675);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (712, 0, 'M', '用户管理', 'el-icon-User', 97, '', 'consumer', '', '', '', 0, 1, 0, 1661832966, 1667870836);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (713, 712, 'C', '用户列表', 'el-icon-User', 0, 'user:list', 'lists', 'consumer/lists/index', '', '', 0, 1, 0, 1661839365, 1663301092);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (714, 714, 'A', '用户编辑', '', 0, 'user:edit', 'detail', 'consumer/lists/detail', '/consumer/lists', '', 0, 0, 0, 1661840502, 1662627718);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (715, 600, 'C', '编辑数据表', '', 0, 'gen:editTable', 'code/edit', 'dev_tools/code/edit', '/dev_tools/code', '', 0, 0, 0, 1661843525, 1661843615);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (717, 0, 'M', '装修管理', 'el-icon-Brush', 94, '', 'decoration', '', '', '', 0, 1, 0, 1661845634, 1667870875);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (718, 717, 'C', '页面装修', 'el-icon-CopyDocument', 10, 'decorate:pages:detail', 'pages', 'decoration/pages/index', '', '', 0, 1, 0, 1661845678, 1681271557);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (719, 717, 'C', '底部导航', 'el-icon-Position', 5, 'decorate:tabbar:detail', 'tabbar', 'decoration/tabbar', '', '', 0, 1, 0, 1661845811, 1681271567);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (720, 800, 'M', '消息通知', '', 9, '', 'message', '', '', '', 0, 1, 0, 1661848742, 1677235429);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (721, 720, 'C', '通知设置', '', 0, 'setting:notice:list', 'notice', 'message/notice/index', '', '', 0, 1, 0, 1661848772, 1662638112);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (722, 720, 'C', '通知详情', '', 0, 'setting:notice:detail', 'notice/edit', 'message/notice/edit', '/setting/message/notice', '', 0, 0, 0, 1661848944, 1663142853);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (723, 720, 'C', '短信设置', '', 0, 'setting:sms:list', 'short_letter', 'message/short_letter/index', '', '', 0, 1, 0, 1661848995, 1662638165);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (724, 500, 'M', '用户设置', '', 8, '', 'user', '', '', '', 0, 1, 0, 1662455407, 1675759066);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (725, 724, 'C', '用户设置', '', 0, 'setting:user:detail', 'setup', 'setting/user/setup', '', '', 0, 1, 0, 1662455555, 1663312225);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (726, 724, 'C', '登录注册', '', 0, 'setting:login:detail', 'login_register', 'setting/user/login_register', '', '', 0, 1, 0, 1662456475, 1663312263);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (728, 500, 'C', '热门搜索', '', 7, 'setting:search:detail', 'search', 'setting/search/index', '', '', 0, 1, 0, 1662540429, 1675759058);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (739, 712, 'C', '用户详情', '', 0, 'user:detail', 'detail', 'consumer/lists/detail', '/consumer/lists', '', 0, 0, 0, 1662628049, 1662628049);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (740, 739, 'A', '用户编辑', '', 0, 'user:edit', '', '', '', '', 0, 1, 0, 1662628085, 1662628085);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (741, 721, 'A', '设置保存', '', 0, 'setting:notice:save', '', '', '', '', 0, 1, 0, 1662638049, 1662638049);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (742, 723, 'A', '短信详情', '', 0, 'setting:sms:detail', '', '', '', '', 0, 1, 0, 1662638180, 1662638180);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (743, 723, 'A', '保存设置', '', 0, 'setting:sms:save', '', '', '', '', 0, 1, 0, 1662638196, 1662638196);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (744, 707, 'A', '设置保存', '', 0, 'channel:h5:save', '', '', '', '', 0, 1, 0, 1662638326, 1662638326);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (745, 710, 'A', '设置保存', '', 0, 'channel:mp:detail', '', '', '', '', 0, 1, 0, 1662638359, 1662638359);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (746, 711, 'A', '保存设置', '', 0, 'channel:wx:save', '', '', '', '', 0, 1, 0, 1662638410, 1662638410);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (747, 709, 'A', '保存', '', 0, 'channel:oa:save', '', '', '', '', 0, 1, 0, 1662638459, 1663310514);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (748, 708, 'C', '菜单管理', '', 0, '', 'menu', 'channel/wx_oa/menu', '', '', 0, 1, 0, 1663050714, 1663050714);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (750, 708, 'C', '关注回复', '', 0, 'channel:oaReplyFollow:list', 'follow', 'channel/wx_oa/reply/follow_reply', '', '', 0, 1, 0, 1663149592, 1664511108);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (751, 708, 'C', '关键字回复', '', 0, 'channel:oaReplyKeyword:list', 'keyword', 'channel/wx_oa/reply/keyword_reply', '', '', 0, 1, 0, 1663149622, 1664511241);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (752, 708, 'C', '默认回复', '', 0, 'channel:oaReplyDefault:list', 'default', 'channel/wx_oa/reply/default_reply', '', '', 0, 1, 0, 1663149650, 1664517685);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (753, 718, 'A', '保存', '', 0, 'decorate:pages:save', '', '', '', '', 0, 1, 0, 1663236648, 1663236648);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (754, 719, 'A', '保存', '', 0, 'decorate:tabbar:save', '', '', '', '', 0, 1, 0, 1663236675, 1663236675);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (756, 748, 'A', '发布', '', 0, 'channel:oaMenu:publish', '', '', '', '', 0, 1, 0, 1663310379, 1663310525);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (757, 748, 'A', '保存', '', 0, 'channel:oaMenu:save', '', '', '', '', 0, 1, 0, 1663310556, 1663310556);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (758, 725, 'A', '保存', '', 0, 'setting:user:save', '', '', '', '', 0, 1, 0, 1663312193, 1663312193);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (759, 726, 'A', '保存', '', 0, 'setting:login:save', '', '', '', '', 0, 1, 0, 1663312289, 1663312289);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (760, 728, 'A', '保存', '', 0, 'setting:search:save', '', '', '', '', 0, 1, 0, 1663312423, 1663312423);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (762, 750, 'A', '新增', '', 0, 'channel:oaReplyFollow:add', '', '', '', '', 1, 1, 0, 1664511131, 1664511131);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (763, 750, 'A', '状态', '', 0, 'channel:oaReplyFollow:status', '', '', '', '', 1, 1, 0, 1664511160, 1664511160);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (764, 750, 'A', '编辑', '', 0, 'channel:oaReplyFollow:edit', '', '', '', '', 1, 1, 0, 1664511177, 1664511190);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (765, 750, 'A', '删除', '', 0, 'channel:oaReplyFollow:del', '', '', '', '', 1, 1, 0, 1664511208, 1664511208);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (766, 751, 'A', '新增', '', 0, 'channel:oaReplyKeyword:add', '', '', '', '', 1, 1, 0, 1664511264, 1664511264);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (767, 751, 'A', '状态', '', 0, 'channel:oaReplyKeyword:status', '', '', '', '', 1, 1, 0, 1664511295, 1664511295);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (768, 751, 'A', '编辑', '', 0, 'channel:oaReplyKeyword:edit', '', '', '', '', 1, 1, 0, 1664511312, 1664511312);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (769, 751, 'A', '删除', '', 0, 'channel:oaReplyKeyword:del', '', '', '', '', 1, 1, 0, 1664511327, 1664511327);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (770, 752, 'A', '新增', '', 0, 'channel:oaReplyDefault:add', '', '', '', '', 1, 1, 0, 1664517709, 1664517709);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (771, 752, 'A', '编辑', '', 0, 'channel:oaReplyDefault:edit', '', '', '', '', 1, 1, 0, 1664517725, 1664517725);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (772, 752, 'A', '状态', '', 0, 'channel:oaReplyDefault:status', '', '', '', '', 1, 1, 0, 1664517757, 1664517757);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (773, 752, 'A', '删除', '', 0, 'channel:oaReplyDefault:del', '', '', '', '', 1, 1, 0, 1664517778, 1664517778);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (774, 774, 'M', '课程管理2', '', 901, '', 'course', '', '', '', 1, 1, 0, 1667371475, 1667371517);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (775, 0, 'M', '课程管理', 'local-icon-dingdan1', 99, '', 'course', '', '', '', 1, 1, 0, 1667371587, 1667870823);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (776, 775, 'M', '课程中心', '', 0, '', 'course', '', '', '', 1, 1, 0, 1667371607, 1681440353);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (777, 776, 'C', '图文管理', '', 0, 'course:course:list', 'imageText', 'course/course/index', '', '', 1, 1, 0, 1667371644, 1680832785);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (778, 776, 'C', '音频课程', '', 0, 'course:course:list', 'audio', 'course/course/index', '', '', 1, 1, 0, 1667371664, 1680832802);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (779, 776, 'C', '视频课程', '', 0, 'course:course:list', 'video', 'course/course/index', '', '', 1, 1, 0, 1667371682, 1680832809);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (780, 775, 'C', '专栏课程', '', 0, '', 'column', 'course/course/index', '', '', 1, 0, 0, 1667371703, 1672026694);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (781, 775, 'C', '课程分类', '', 0, 'course:category:list', 'category', 'course/category/index', '', '', 1, 1, 0, 1667371723, 1680833011);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (782, 775, 'C', '课程评价', '', 0, 'course:evaluate:list', 'evaluate', 'course/evaluate/index', '', '', 1, 1, 0, 1667371746, 1680833083);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (783, 0, 'M', '讲师管理', 'el-icon-Avatar', 96, '', 'teacher', '', '', '', 1, 1, 0, 1667544548, 1667870851);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (784, 783, 'C', '讲师列表', '', 0, 'teacher:teacher:list', 'index', 'teacher/lists/index', '', '', 1, 1, 0, 1667544636, 1680833314);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (785, 0, 'M', '订单管理', 'el-icon-Pointer', 95, '', 'order', '', '', '', 1, 1, 0, 1667546759, 1667870857);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (786, 785, 'C', '订单列表', '', 0, 'order:order:list', 'index', 'order/lists/index', '', '', 1, 1, 0, 1667546800, 1680833368);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (787, 0, 'M', '营销中心', 'el-icon-Aim', 93, '', 'application', '', '', '', 1, 1, 0, 1667547634, 1680854994);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (788, 787, 'C', '专题活动', '', 0, 'application:application:list', 'subject', 'application/subject/index', '', '', 1, 1, 0, 1667547666, 1680833478);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (789, 800, 'C', '用户充值', '', 20, 'application:charge:dispose', 'user_charge', 'application/user_charge/index', '', '', 1, 1, 0, 1667547700, 1681271602);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (790, 0, 'M', '财务管理', 'el-icon-GoodsFilled', 92, '', 'finance', '', '', '', 1, 1, 0, 1667552760, 1667870892);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (791, 790, 'C', '财务概况', '', 0, 'application:finance:summarize', 'summarize', 'finance/summarize', '', '', 1, 1, 0, 1667552785, 1680834251);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (792, 790, 'C', '充值记录', '', 0, 'application:finance:charge_record', 'charge_record', 'finance/charge_record', '', '', 1, 1, 0, 1667552814, 1680834270);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (793, 790, 'C', '余额明细', '', 0, 'application:finance:balance_statement', 'balance_statement', 'finance/balance_statement', '', '', 1, 1, 0, 1667552837, 1680834311);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (794, 790, 'C', '退款记录', '', 0, 'application:finance:record', 'record', 'finance/record/index', '', '', 1, 1, 0, 1667552858, 1680834326);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (795, 500, 'M', '支付设置', '', 0, '', 'payment', '', '', '', 1, 1, 0, 1667794135, 1667794135);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (796, 795, 'C', '支付配置', '', 0, 'setting:payment:config', 'config', 'setting/payment/payment_config/index', '', '', 1, 1, 0, 1667794180, 1680834534);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (797, 795, 'C', '支付方式', '', 0, 'setting:payment:list', 'way', 'setting/payment/payment_way/index', '', '', 1, 1, 0, 1667794206, 1680834495);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (798, 550, 'C', '定时任务', '', 0, '', 'task/index', 'setting/system/task/index', '', '', 1, 1, 0, 1668164344, 1668164344);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (799, 500, 'C', '交易设置', '', 0, 'setting:transaction:config', 'setting/transaction', 'setting/order/index', '', '', 1, 1, 0, 1669703588, 1680834666);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (800, 0, 'M', '应用管理', 'el-icon-Loading', 93, '', 'app', '', '', '', 1, 1, 0, 1677235400, 1677235666);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (801, 801, 'C', '优惠券', '', 0, '', 'coupon/coupon', 'application/coupon/coupon/index', '', '', 1, 1, 0, 1677581681, 1677581969);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (802, 803, 'C', '领取记录', '', 0, 'application:coupon:recorder', 'recorder', 'application/coupon/recorder/index', '', '', 1, 1, 0, 1677581863, 1680833769);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (803, 787, 'M', '优惠券', '', 0, '', 'coupon', '', '', '', 1, 1, 0, 1677581948, 1677581948);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (804, 803, 'C', '优惠券', '', 2, 'application:coupon:list', 'coupon', 'application/coupon/coupon/index', '', '', 1, 1, 0, 1677582045, 1680833738);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (805, 787, 'M', '积分签到', '', 0, '', 'integral', 'application/integral/dispose', '', '', 1, 1, 0, 1680575907, 1680575974);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (806, 805, 'C', '签到配置', '', 0, 'application:integral:dispose', 'dispose', 'application/integral/dispose', '', '', 1, 1, 0, 1680575997, 1680833860);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (807, 805, 'C', '签到记录', '', 0, 'application:integral:recorder', 'recorder', 'application/integral/recorder', '', '', 1, 1, 0, 1680576035, 1680833917);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (808, 787, 'C', '消费奖励', '', 0, '', 'consumerReward', 'application/consumerReward/index', '', '', 1, 1, 0, 1680591851, 1680591851);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (809, 808, 'A', '保存', '', 0, 'application:consumerReward:edit', '', '', '', '', 1, 1, 0, 1680591903, 1680591903);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (810, 777, 'A', '新增课程', '', 0, '\'course:course:add\'', '', '', '', '', 1, 1, 0, 1680832721, 1680832721);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (811, 778, 'A', '新增课程', '', 0, 'course:course:add', '', '', '', '', 1, 1, 0, 1680832745, 1680832796);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (812, 779, 'A', '新增课程', '', 0, 'course:course:add', '', '', '', '', 1, 1, 0, 1680832754, 1680832815);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (813, 781, 'A', '新增分类', '', 0, 'course:category:add', '', '', '', '', 1, 1, 0, 1680833001, 1680833001);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (814, 784, 'A', '新增讲师', '', 0, 'teacher:teacher:add', '', '', '', '', 1, 1, 0, 1680833327, 1680833327);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (815, 788, 'A', '新增专题活动', '', 0, 'application:application:add', '', '', '', '', 1, 1, 0, 1680833500, 1680833500);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (816, 804, 'A', '新增优惠券', '', 0, 'application:coupon:add', '', '', '', '', 1, 1, 0, 1680833750, 1680833750);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (817, 806, 'A', '保存', '', 0, 'application:integral:edit', '', '', '', '', 1, 1, 0, 1680833876, 1680833876);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (818, 789, 'A', '保存', '', 0, 'application:charge:edit', '', '', '', '', 1, 1, 0, 1680834110, 1680834110);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (819, 797, 'A', '编辑支付方式', '', 0, 'setting:payment:edit', '', '', '', '', 1, 1, 0, 1680834509, 1680834509);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (820, 799, 'A', '保存', '', 0, 'setting:transaction:edit', '', '', '', '', 1, 1, 0, 1680834678, 1680834678);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (821, 790, 'C', '积分明细', '', 0, 'finance:integral_detail:list', 'integral_detail', 'finance/integral_detail', '', '', 1, 1, 0, 1680835900, 1680835900);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (822, 787, 'C', '积分抵扣', '', 0, '', 'pointDeduction', 'application/pointDeduction/index', '', '', 1, 1, 0, 1681093738, 1681097264);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (823, 777, 'A', '批量上架', '', 0, 'course:course:bathListing', '', '', '', '', 1, 1, 0, 1681440507, 1681440507);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (824, 777, 'A', '批量下架', '', 0, 'course:course:bathDelisting', '', '', '', '', 1, 1, 0, 1681440523, 1681440523);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (825, 777, 'A', '批量删除', '', 0, 'course:course:bathDel', '', '', '', '', 1, 1, 0, 1681440549, 1681440549);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (826, 777, 'A', '编辑', '', 0, 'course:course:edit', '', '', '', '', 1, 1, 0, 1681440608, 1681440608);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (827, 777, 'A', '课程目录', '', 0, 'course:course:catalogue', '', '', '', '', 1, 1, 0, 1681440750, 1681440750);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (828, 777, 'A', '课程资料', '', 0, 'course:course:material', '', '', '', '', 1, 1, 0, 1681440775, 1681440775);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (829, 777, 'A', '上/下架课程', '', 0, 'course:course:status', '', '', '', '', 1, 1, 0, 1681440800, 1681440800);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (830, 777, 'A', '删除课程', '', 0, 'course:course:del', '', '', '', '', 1, 1, 0, 1681440819, 1681440819);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (831, 778, 'A', '批量上架', '', 0, 'course:course:bathListing', '', '', '', '', 1, 1, 0, 1681440891, 1681440891);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (832, 778, 'A', '批量下架', '', 0, 'course:course:bathDelisting', '', '', '', '', 1, 1, 0, 1681440906, 1681440906);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (833, 778, 'A', '批量删除', '', 0, 'course:course:bathDel', '', '', '', '', 1, 1, 0, 1681440944, 1681440944);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (834, 778, 'A', '编辑', '', 0, 'course:course:edit', '', '', '', '', 1, 1, 0, 1681440959, 1681440959);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (835, 778, 'A', '课程目录', '', 0, 'course:course:catalogue', '', '', '', '', 1, 1, 0, 1681440974, 1681440974);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (836, 778, 'A', '课程资料', '', 0, 'course:course:material', '', '', '', '', 1, 1, 0, 1681440989, 1681440989);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (837, 778, 'A', '上/下架课程', '', 0, 'course:course:status', '', '', '', '', 1, 1, 0, 1681441008, 1681441008);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (838, 778, 'A', '删除课程', '', 0, 'course:course:del', '', '', '', '', 1, 1, 0, 1681441023, 1681441023);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (839, 779, 'A', '批量上架', '', 0, 'course:course:bathListing', '', '', '', '', 1, 1, 0, 1681441062, 1681441062);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (840, 779, 'A', '批量下架', '', 0, 'course:course:bathDelisting', '', '', '', '', 1, 1, 0, 1681441074, 1681441074);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (841, 779, 'A', '批量删除', '', 0, 'course:course:bathDel', '', '', '', '', 1, 1, 0, 1681441087, 1681441087);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (842, 779, 'A', '编辑', '', 0, 'course:course:edit', '', '', '', '', 1, 1, 0, 1681441103, 1681441103);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (843, 779, 'A', '课程目录', '', 0, 'course:course:catalogue', '', '', '', '', 1, 1, 0, 1681441120, 1681441120);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (844, 779, 'A', '课程资料', '', 0, 'course:course:material', '', '', '', '', 1, 1, 0, 1681441135, 1681441135);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (845, 779, 'A', '上/下架课程', '', 0, 'course:course:status', '', '', '', '', 1, 1, 0, 1681441152, 1681441152);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (846, 779, 'A', 'course:course:del', '', 0, '删除课程', '', '', '', '', 1, 1, 0, 1681441169, 1681441169);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (847, 781, 'A', '查询', '', 0, 'course:category:query', '', '', '', '', 1, 1, 0, 1681441363, 1681441363);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (848, 781, 'A', '编辑', '', 0, 'course:category:edit', '', '', '', '', 1, 1, 0, 1681441378, 1681441378);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (849, 781, 'A', '删除', '', 0, 'course:category:del', '', '', '', '', 1, 1, 0, 1681441398, 1681441398);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (850, 782, 'A', '编辑/回复评论', '', 0, 'course:evaluate:edit', '', '', '', '', 1, 1, 0, 1681441500, 1681441500);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (851, 782, 'A', '删除', '', 0, 'course:evaluate:del', '', '', '', '', 1, 1, 0, 1681441516, 1681441516);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (852, 713, 'A', '详情', '', 0, 'user:list:detail', '', '', '', '', 1, 1, 0, 1681441793, 1681441817);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (853, 713, 'A', '调整余额', '', 0, 'user:list:adjustBalance', '', '', '', '', 1, 1, 0, 1681441875, 1681441875);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (854, 713, 'A', '调整积分', '', 0, 'user:list:adjustIntegral', '', '', '', '', 1, 1, 0, 1681441891, 1681441891);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (855, 713, 'A', '发放优惠券', '', 0, 'user:list:distributeCoupons', '', '', '', '', 1, 1, 0, 1681441904, 1681441904);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (856, 739, 'A', '调整余额', '', 0, 'user:list:adjustBalance', '', '', '', '', 1, 1, 0, 1681442186, 1681442186);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (857, 739, 'A', '调整积分', '', 0, 'user:list:adjustIntegral', '', '', '', '', 1, 1, 0, 1681442200, 1681442200);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (858, 739, 'A', '发放优惠券', '', 0, 'user:list:distributeCoupons', '', '', '', '', 1, 1, 0, 1681442223, 1681442223);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (859, 784, 'A', '编辑讲师', '', 0, 'teacher:teacher:edit', '', '', '', '', 1, 1, 0, 1681442589, 1681442589);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (860, 784, 'A', '删除', '', 0, 'teacher:teacher:del', '', '', '', '', 1, 1, 0, 1681442602, 1681442602);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (861, 786, 'A', '详情', '', 0, 'order:order:detail', '', '', '', '', 1, 1, 0, 1681442680, 1681442680);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (862, 788, 'A', '编辑', '', 0, 'application:application:edit', '', '', '', '', 1, 1, 0, 1681442799, 1681442799);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (863, 788, 'A', '专区课程', '', 0, 'application:application:course', '', '', '', '', 1, 1, 0, 1681442815, 1681442815);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (864, 788, 'A', '删除', '', 0, 'application:application:del', '', '', '', '', 1, 1, 0, 1681442826, 1681442826);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (865, 804, 'A', '详情', '', 0, 'application:coupon:detail', '', '', '', '', 1, 1, 0, 1681442943, 1681442953);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (866, 804, 'A', '编辑', '', 0, 'application:coupon:edit', '', '', '', '', 1, 1, 0, 1681442967, 1681442967);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (867, 804, 'A', '删除', '', 0, 'application:coupon:del', '', '', '', '', 1, 1, 0, 1681442982, 1681442982);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (868, 804, 'A', '开始发放', '', 0, 'application:coupon:start', '', '', '', '', 1, 1, 0, 1681443037, 1681443042);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (869, 804, 'A', '结束发放', '', 0, 'application:coupon:end', '', '', '', '', 1, 1, 0, 1681443057, 1681443057);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (870, 802, 'A', '作废', '', 0, 'application:couponRecord:cancel', '', '', '', '', 1, 1, 0, 1681443138, 1681443138);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (871, 822, 'A', '保存', '', 0, 'application:deduction:edit', '', '', '', '', 1, 1, 0, 1681443266, 1681443266);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (872, 798, 'A', '添加', '', 0, 'setting:task:add', '', '', '', '', 1, 1, 0, 1681443428, 1681443428);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (873, 798, 'A', '编辑', '', 0, 'setting:task:edit', '', '', '', '', 1, 1, 0, 1681443440, 1681443440);
INSERT INTO `ls_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (874, 798, 'A', '删除', '', 0, 'setting:task:del', '', '', '', '', 1, 1, 0, 1681443454, 1681443454);
COMMIT;

-- ----------------------------
-- Table structure for ls_system_auth_perm
-- ----------------------------
DROP TABLE IF EXISTS `ls_system_auth_perm`;
CREATE TABLE `ls_system_auth_perm` (
  `id` varchar(100) NOT NULL DEFAULT '' COMMENT '主键',
  `role_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '角色ID',
  `menu_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '菜单ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统角色菜单表';

-- ----------------------------
-- Records of ls_system_auth_perm
-- ----------------------------
BEGIN;
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('02ac8e45a58650fb4f8e6057af740a0f', 1, 135);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('05413bc32500444a1c21f074b1fc67d4', 1, 600);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('05d7bb665321729c67f8699ccb233867', 1, 617);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('063393b07391978f03e9208beb84f609', 1, 553);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('09c3e83a978ad0818416cbb02d5e2e79', 1, 611);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('0dff5fe06f57bd6488bdfc21c4e3e246', 1, 120);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('10e930a56223f5ce97d59e1784d4540f', 1, 773);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('1388529ab383c431d567f39b232a1f0c', 1, 618);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('16e2afdaf2bce152cf56a36943510db9', 1, 777);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('1907cad413cb32992c86d2495446da8f', 1, 552);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('1b652250ce21ed44eee3b215d8c1bf0f', 1, 792);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('1c14d37e866868e9be70bd4cfd43f6be', 1, 781);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('1f2d3ea57e8c858b07af45f92da42bfd', 1, 715);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('1fc260dc308bb526f28d27367245c4a3', 1, 204);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('202f3c1f1b647a971f6e08e713d7ef88', 1, 751);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('214decb35a92c7d09cc11d98624b7331', 1, 144);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('24b8a6f9e111edeca0e6c9cbc68906f2', 1, 556);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('2603bead22cc204b84b4aaab76fe39a1', 1, 779);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('282202f80c279136b6e4a6c06c26bcff', 1, 723);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('2a4d66c25cc869fe10cc0127d788c742', 1, 130);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('2c3fcdd7481559e8f9eb30839a944915', 1, 788);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('2c99cd9400a7d5515f3fba6f62442ed1', 1, 502);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('2dcc9e9631514507063ebfe558bc7836', 1, 206);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('2df16eded80a23dad6260462d809101f', 1, 782);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('2f8b12c3142160dc6d5275e5f0d2dbd0', 1, 757);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('3215bc128f16f6564bac3f59039a2e5a', 1, 100);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('32ac9c8d7148bec36c4e34b15f460110', 1, 110);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('346e21f6495678995f4343bb6ea2b510', 1, 510);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('34c089bebe9349aacf533d73a836844e', 1, 216);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('365e5edb863b11c756d95e8bb4158a26', 1, 724);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('36de3d5c4d90f24b01006cd1e93831b2', 1, 123);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('37e373eb4b39910476b433b90ccf8251', 1, 614);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('3840fc108961ab0ba3db6b537912f402', 1, 706);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('3e590907323d3038321261fb77e1c6f0', 1, 741);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('3e9a85353a1c1c441ea2f4decc135196', 1, 203);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('403f106164044c1aa76bfda8b00ccdde', 1, 728);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('41e9d7ec331a7102a1451937d4b8e924', 1, 122);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('43c49bc9f01fa9332734362cab8be486', 1, 711);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('45a61e9f229dfda91889a31629bc77c9', 1, 772);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('48916921a729f751856f10a076088a44', 1, 202);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('508ce03574e2f90c2a5c4d48ac640a4d', 1, 746);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('51a76d666fe2a387013439712d2ed7b9', 1, 709);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('52d20d9d3437cb1e0959cd8eca67301f', 1, 101);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('530a8b595424058bf309a78bf500b308', 1, 215);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('556304cea97ee1eae9098fb524bfbad6', 1, 739);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('56b68da495e637ce675b57c1163b555a', 1, 740);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('59424b0db98d11df50c1bbaf0aadd8d9', 1, 765);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('5a5d2360ed18cf16840f812d292c2856', 1, 555);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('5b97c06f671922dee0cd919ccd817e87', 1, 771);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('5d461eccdd785cf8ca37ab19f75e8584', 1, 505);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('5df4fc84f2e33406127095ddd62da07b', 1, 721);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('605143a57ac05e9f3370a0525b527494', 1, 787);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('611097af6a00cb652c863f7b687363cd', 1, 134);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('61ce042945d9f50dc49f4eb90f6b8d03', 1, 102);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('642a13479c1a91824096e06e6fd1ed45', 1, 550);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('66200ab8ee6bb31024398f71a6dea26d', 1, 114);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('689b3733e186735b5665ba0f82df790d', 1, 503);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('68d880ff445e56df9730144052cb0a2c', 1, 707);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('6903d5addaeeb24234f6a1e18431bae7', 1, 713);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('6b9a70c2837376a42e7541ee11e9b148', 1, 789);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('6ca0a001c765ae2711febecc8eca04ec', 1, 786);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('6d743d51d1dbc83fcf77260508007f12', 1, 785);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('737521cd9fda3ae585a94eed2d6df72a', 1, 754);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('738dd29a9f26c1fbab5386c4b14945d1', 1, 104);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('74ce7948152324d0c0f75ef265bed6c6', 1, 133);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('74e12b255003a0e4738f7dd7a5765273', 1, 790);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('7537a66d408c0da8d2f2767e2509fa6b', 1, 500);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('75650d1507eb914b7c4b5f59ce4bc75c', 1, 783);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('79264622b59352bb0b197c7be9492614', 1, 796);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('7a96d7f496d2b83c0e789a1497ef9e7f', 1, 758);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('7c1f2839d2b005edfb8a4154e63b6ee0', 1, 745);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('7e4783dfdf1d0a62f6b60e9b9a8c0457', 1, 141);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('80cb72c4948db9bd56b0304530686abf', 1, 515);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('82306b01d60a1b53580c5df32ac38731', 1, 759);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('829bf4fb3bb99135594b297371977cbe', 1, 750);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('8360d07306aaf81140425b336d46d98c', 1, 207);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('843f1d973362d96081ade160a4096b8c', 1, 112);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('86bd51f58ff205322bc1a27aac892a92', 1, 208);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('89699688f8f96287cf9a014fc7e4daa2', 1, 718);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('8a1111f27a3971b89f89dc7d9e7c9888', 1, 209);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('8aed447d2a93872577e3d6ba78ab880f', 1, 205);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('8b59111fd5291ab0ac7b3742d85fa372', 1, 756);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('92a991eae3376a4bb34516607fbb454a', 1, 762);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('92b1d1f20ded7f1283c2b4b4fdd5ad08', 1, 511);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('93c218f93b5c854cdb87cca8c9d681ab', 1, 791);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('945ab59249867c9d40fba689f395b08f', 1, 766);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('95f291363ded9a60b2350368b3f18bf9', 1, 111);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('96aaab33b01f269cbba144269c992982', 1, 797);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('9a5801fad8d1c02d9191180d4781b0c7', 1, 793);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('9af49dae5fc53d755164c4da99789d8e', 1, 775);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('9bc32747b315a745977ca201c61365ed', 1, 121);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('9ec2f68976c89aef649a2d98dcf39763', 1, 744);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('a43598d897e9c24ae340f23ae748cc2b', 1, 743);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('a56961d034b26573252f1bad2ffa6ab0', 1, 613);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('a70b0a7ed3e602c67b25e3ede28b2281', 1, 764);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('a8f3c42ede42c5538695a8ae11da07e5', 1, 770);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('a9318bd8324762ec59ae872fd887a769', 1, 616);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('a9ec5da360d9634b5f3cfa067b9b7914', 1, 722);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('aaeb35184005c995290b6af13a04b8bb', 1, 784);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('ac2cf7d525a308a4d90fa6a8d2e15c85', 1, 518);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('ac4801969dc28e29d4760df80509734e', 1, 132);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('b5bc382ee10deadcafbceae90c2eec08', 1, 105);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('b5cace742e3d616989d524bff87db1c3', 1, 521);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('b662c94bc3c47af357061a60ac71d25d', 1, 769);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('b714c90d11f9679ec909fd61023cfb25', 1, 140);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('ba0ed9ef4859e6be01f47a9dbb0e22a0', 1, 201);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('ba781f69c6fb0fa1a45563acd7f5e18d', 1, 516);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('bbaff2ddaa8c5b918937e74b0c7873b7', 1, 768);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('bc79520477ac4de22d6f09af5a0cd9df', 1, 612);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('c1e9baf43e4557e5c65e5281787ce58c', 1, 522);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('c21437f2b15201fb4f9469619b3f2b6a', 1, 217);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('c76d6b0cb138762dd97155203ca8f67d', 1, 778);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('c893b8331d9c0c96b2bd1a7f3a41d48f', 1, 131);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('c92d3279504e3218bb691b818d54b958', 1, 719);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('c97df50013623903410eea8c04073aab', 1, 710);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('cad9f4dbe80531c9cf6e83935543a537', 1, 753);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('d1872576fba4fcbfe74b4ffa739fc819', 1, 794);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('d1f83abf15bd18009e13ff732240200e', 1, 506);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('d226286869b4b61a690344e0ec93e1c1', 1, 517);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('d3dedbb7dc13d201d50e954653f0b582', 1, 143);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('d4e88a8b06f083158bf8aa6b721ac559', 1, 776);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('d6297a923b089dcc445cc21916e1a27c', 1, 717);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('d6dbffc50fd53a538f362c63d4e66684', 1, 520);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('d72bb44ab7c970b45c8d94163f70e559', 1, 551);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('d74c7478cd8989d10b28382e6331acdd', 1, 720);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('d7c8fe28324d1f06d3c8785a84501d12', 1, 708);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('dc13d9f1563fda72f6578cc95e8fdf23', 1, 767);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('dd908f8f329acfe3e857f1e2ebc934ef', 1, 113);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('df25f4054c160936c21cbd3df3735feb', 1, 501);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('e24e7fbc880b7e2a04dce5c9fb444b07', 1, 103);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('e5b9c6661a9c5abbdfa446ccf38e024f', 1, 752);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('e70dd780da8384d4a1b458617fcf6680', 1, 200);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('e761f9ff6730149e0c2a5d8f912d1fc5', 1, 742);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('e7907a31158b42f169f562bf00985eda', 1, 748);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('e7e95338620c61c0a86978a320bccea1', 1, 747);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('e9580974c833f089f8db8a89aeff6428', 1, 610);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('eae038d28251c1ed29d2d8d3e8587480', 1, 712);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('eb031999c7c64f16d352e2a4e85ff1f4', 1, 763);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('ebf24affd95dc30b645565be6d093577', 1, 760);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('ee747c0194c5db066bb6026f62135eb8', 1, 726);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('ee7ae989c689f28a16d8d66eb0e18a61', 1, 795);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('f04c1dfb5071b5eee09768af9e98d3e4', 1, 142);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('f3d26808de9ff560b38d4d153f0ae34b', 1, 519);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('f509abe200b70a722776ad8135b7a13a', 1, 725);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('fa9651799e764a43598a6e0b1e8c6114', 1, 1);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('fbce705be8ba24a959678f10b829e7b8', 1, 700);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('fbd7c7fbc743cb44a617a6bd61172539', 1, 701);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('fd8caff3784cc39224c2d5b1529aa4c3', 1, 124);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('fee585e41c70870bb4c9aefb1a3183ec', 1, 780);
INSERT INTO `ls_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('ffcb785b29c2b24d07f55793ef5588d2', 1, 106);
COMMIT;

-- ----------------------------
-- Table structure for ls_system_auth_post
-- ----------------------------
DROP TABLE IF EXISTS `ls_system_auth_post`;
CREATE TABLE `ls_system_auth_post` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `code` varchar(30) NOT NULL DEFAULT '' COMMENT '岗位编码',
  `name` varchar(30) NOT NULL DEFAULT '' COMMENT '岗位名称',
  `remarks` varchar(250) NOT NULL DEFAULT '' COMMENT '岗位备注',
  `sort` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '岗位排序',
  `is_stop` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否停用: 0=否, 1=是',
  `is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除: 0=否, 1=是',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `delete_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COMMENT='系统岗位管理表';

-- ----------------------------
-- Records of ls_system_auth_post
-- ----------------------------
BEGIN;
INSERT INTO `ls_system_auth_post` (`id`, `code`, `name`, `remarks`, `sort`, `is_stop`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (1, '1', '开发工程师', '', 1, 0, 0, 1665480664, 1665481233, 0);
INSERT INTO `ls_system_auth_post` (`id`, `code`, `name`, `remarks`, `sort`, `is_stop`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (2, '2', '测试工程师', '', 1, 1, 0, 1665481278, 1671155272, 0);
INSERT INTO `ls_system_auth_post` (`id`, `code`, `name`, `remarks`, `sort`, `is_stop`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (3, '22', '222', '222', 0, 1, 0, 1670315031, 1670315041, 0);
INSERT INTO `ls_system_auth_post` (`id`, `code`, `name`, `remarks`, `sort`, `is_stop`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (4, '4424', '而我4', '', 0, 0, 0, 1671077107, 1671077107, 0);
INSERT INTO `ls_system_auth_post` (`id`, `code`, `name`, `remarks`, `sort`, `is_stop`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (5, '31313', '313131', '', 0, 0, 0, 1671155266, 1671155266, 0);
COMMIT;

-- ----------------------------
-- Table structure for ls_system_auth_role
-- ----------------------------
DROP TABLE IF EXISTS `ls_system_auth_role`;
CREATE TABLE `ls_system_auth_role` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(100) NOT NULL DEFAULT '' COMMENT '角色名称',
  `remark` varchar(200) NOT NULL DEFAULT '' COMMENT '备注信息',
  `sort` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '角色排序',
  `is_disable` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否禁用: 0=否, 1=是',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='系统角色管理表';

-- ----------------------------
-- Records of ls_system_auth_role
-- ----------------------------
BEGIN;
INSERT INTO `ls_system_auth_role` (`id`, `name`, `remark`, `sort`, `is_disable`, `create_time`, `update_time`) VALUES (1, '111', '', 0, 0, 1667984685, 1667984792);
INSERT INTO `ls_system_auth_role` (`id`, `name`, `remark`, `sort`, `is_disable`, `create_time`, `update_time`) VALUES (2, '3333333', '333333333333333', 0, 0, 1670317506, 1670317506);
COMMIT;

-- ----------------------------
-- Table structure for ls_system_config
-- ----------------------------
DROP TABLE IF EXISTS `ls_system_config`;
CREATE TABLE `ls_system_config` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `type` varchar(30) DEFAULT '' COMMENT '类型',
  `name` varchar(60) NOT NULL DEFAULT '' COMMENT '键',
  `value` text COMMENT '值',
  `create_time` int(10) unsigned DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=83 DEFAULT CHARSET=utf8mb4 COMMENT='系统全局配置表';

-- ----------------------------
-- Records of ls_system_config
-- ----------------------------
BEGIN;
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (1, 'storage', 'default', 'local', 1660620367, 1670376749);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (2, 'storage', 'local', '{\"name\":\"本地存储\"}', 1660620367, 1670376749);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (3, 'storage', 'qiniu', '{\"name\":\"七牛云存储\",\"bucket\":\"\",\"secretKey\":\"\",\"accessKey\":\"\",\"domain\":\"\"}', 1660620367, 1660620367);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (4, 'storage', 'aliyun', '{\"name\":\"阿里云存储\",\"bucket\":\"\",\"secretKey\":\"\",\"accessKey\":\"\",\"domain\":\"\"}', 1660620367, 1662620071);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (5, 'storage', 'qcloud', '{\"name\":\"腾讯云存储\",\"bucket\":\"\",\"secretKey\":\"\",\"accessKey\":\"\",\"domain\":\"\",\"region\":\"\"}', 1660620367, 1660620367);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (6, 'sms', 'default', 'aliyun', 1660620367, 1671531989);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (7, 'sms', 'aliyun', '{\"name\":\"阿里云短信\",\"alias\":\"aliyun\",\"sign\":\"广州好象科技\",\"appKey\":\"LTAI5tHT3svXXXXvjjebK\",\"secretKey\":\"193keMSjHDBXXXPbDDST9IOzm\"}', 1660620367, 1671531989);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (8, 'sms', 'tencent', '{\"name\":\"腾讯云短信\",\"alias\":\"tencent\",\"sign\":\"\",\"appId\":\"\",\"secretId\":\"\",\"secretKey\":\"\"}', 1660620367, 1660620367);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (9, 'sms', 'huawei', '{\"name\":\"华为云短信\",\"alias\":\"huawei\"}', 1660620367, 1660620367);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (10, 'website', 'name', '知识付费Java版', 1660620367, 1671159925);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (11, 'website', 'logo', '/api/static/backend_logo.png', 1660620367, 1671159925);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (12, 'website', 'favicon', '/api/static/backend_favicon.ico', 1660620367, 1671159925);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (13, 'website', 'backdrop', '/api/static/backend_backdrop.png', 1660620367, 1671159926);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (14, 'website', 'copyright', '[{\"name\":\"LikeShop知识付费\",\"link\":\"http://www.beian.gov.cn\"}]', 1660620367, 1670317670);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (15, 'website', 'shopName', 'LikeShop知识付费', 1631255140, 1671159926);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (16, 'website', 'shopLogo', '/api/static/shop_logo.png', 1631255140, 1671159926);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (17, 'protocol', 'service', '{\"name\":\"服务协议\",\"content\":\"<p>iiiiii</p>\"}', 1660620367, 1670317679);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (18, 'protocol', 'privacy', '{\"name\":\"隐私协议\",\"content\":\"<p>777</p>\"}', 1660620367, 1670317679);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (19, 'tabbar', 'style', '{\"defaultColor\":\"#4A5DFF\",\"default_color\":\"#999999\",\"default_color1\":\"#4B2F2F\",\"selectedColor\":\"#EA5455\",\"selected_color\":\"#4173ff\"}', 1660620367, 1672397751);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (20, 'search', 'isHotSearch', '1', 1660620367, 1671532082);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (30, 'h5_channel', 'status', '1', 1660620367, 1671094139);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (31, 'h5_channel', 'close', '1', 1660620367, 1671094139);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (32, 'h5_channel', 'url', 'www.baidu.com', 1660620367, 1671094139);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (40, 'mp_channel', 'name', '', 1660620367, 1668479735);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (41, 'mp_channel', 'primaryId', '', 1660620367, 1668479735);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (42, 'mp_channel', 'appId', 'wx386XXXX8b38935', 1660620367, 1668479735);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (43, 'mp_channel', 'appSecret', 'dabd00aXXXXXX5542c', 1660620367, 1668479735);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (44, 'mp_channel', 'qrCode', '', 1660620367, 1668479735);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (50, 'wx_channel', 'appId', '', 1660620367, 1660620367);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (51, 'wx_channel', 'appSecret', '', 1660620367, 1660620367);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (55, 'oa_channel', 'name', '', 1660620367, 1671679214);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (56, 'oa_channel', 'primaryId', ' ', 1660620367, 1671679214);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (57, 'oa_channel', 'qrCode', '', 1662551337, 1671679214);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (58, 'oa_channel', 'appId', 'wx1bacXXXf1495', 1660620367, 1671679214);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (59, 'oa_channel', 'appSecret', 'a79d27eaXXX8ed9cfe7a5', 1660620367, 1671679214);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (60, 'oa_channel', 'url', '', 1660620367, 1671679214);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (61, 'oa_channel', 'token', '', 1660620367, 1671679214);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (62, 'oa_channel', 'encodingAesKey', '', 1660620367, 1671679214);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (63, 'oa_channel', 'encryptionType', '1', 1660620367, 1671679214);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (64, 'oa_channel', 'menus', '[]', 1631255140, 1663118712);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (70, 'login', 'loginWay', '1,2', 1660620367, 1671099706);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (71, 'login', 'forceBindMobile', '0', 1660620367, 1671099706);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (72, 'login', 'openAgreement', '1', 1660620367, 1671099706);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (73, 'login', 'openOtherAuth', '1', 1660620367, 1671099706);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (74, 'login', 'autoLoginAuth', '1,2', 1660620367, 1671099706);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (80, 'user', 'defaultAvatar', '/api/static/default_avatar.png', 1660620367, 1662535156);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (81, 'website', 'contacts', '帅哥', 1671159926, 1671159926);
INSERT INTO `ls_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (82, 'website', 'contactNumber', '110', 1671159926, 1671159926);
COMMIT;

-- ----------------------------
-- Table structure for ls_system_log_login
-- ----------------------------
DROP TABLE IF EXISTS `ls_system_log_login`;
CREATE TABLE `ls_system_log_login` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '注解',
  `admin_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '管理员ID',
  `username` varchar(30) NOT NULL DEFAULT '' COMMENT '登录账号',
  `ip` varchar(30) NOT NULL COMMENT '登录地址',
  `os` varchar(100) NOT NULL DEFAULT '' COMMENT '操作系统',
  `browser` varchar(100) DEFAULT '' COMMENT '浏览器',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '操作状态: 1=成功, 2=失败',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COMMENT='系统登录日志表';

-- ----------------------------
-- Records of ls_system_log_login
-- ----------------------------
BEGIN;
INSERT INTO `ls_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (1, 1, 'admin', '127.0.0.1', 'Mac OS X', 'Chrome 10', 0, 1672062200);
INSERT INTO `ls_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (2, 1, 'admin', '127.0.0.1', 'Mac OS X', 'Chrome 10', 1, 1672062225);
INSERT INTO `ls_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (3, 1, 'admin', '127.0.0.1', 'Mac OS X', 'Chrome 10', 1, 1672147076);
INSERT INTO `ls_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (4, 1, 'admin', '113.67.10.138', 'Mac OS X', 'Chrome 10', 1, 1672385958);
INSERT INTO `ls_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (5, 1, 'admin', '113.67.10.138', 'Mac OS X', 'Chrome 10', 1, 1672387326);
INSERT INTO `ls_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (6, 1, 'admin', '113.67.10.138', 'Mac OS X', 'Chrome 10', 1, 1672387913);
INSERT INTO `ls_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (7, 1, 'admin', '116.16.157.160', 'Mac OS X', 'Chrome 10', 1, 1672388061);
INSERT INTO `ls_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (8, 1, 'admin', '113.67.10.138', 'Mac OS X', 'Chrome 10', 1, 1672396936);
INSERT INTO `ls_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (9, 1, 'admin', '113.67.10.138', 'Mac OS X', 'Chrome 10', 1, 1672396962);
INSERT INTO `ls_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (10, 1, 'admin', '116.16.157.160', 'Mac OS X', 'Chrome 10', 1, 1672397209);
COMMIT;

-- ----------------------------
-- Table structure for ls_system_log_operate
-- ----------------------------
DROP TABLE IF EXISTS `ls_system_log_operate`;
CREATE TABLE `ls_system_log_operate` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `admin_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '操作人ID',
  `type` varchar(30) NOT NULL DEFAULT '' COMMENT '请求类型: GET/POST/PUT',
  `title` varchar(30) DEFAULT '' COMMENT '操作标题',
  `ip` varchar(30) NOT NULL DEFAULT '' COMMENT '请求IP',
  `url` varchar(200) NOT NULL DEFAULT '' COMMENT '请求接口',
  `method` varchar(200) NOT NULL DEFAULT '' COMMENT '请求方法',
  `args` text COMMENT '请求参数',
  `error` text COMMENT '错误信息',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '执行状态: 1=成功, 2=失败',
  `start_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '开始时间',
  `end_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '结束时间',
  `task_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '执行耗时',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COMMENT='系统操作日志表';

-- ----------------------------
-- Records of ls_system_log_operate
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_system_log_sms
-- ----------------------------
DROP TABLE IF EXISTS `ls_system_log_sms`;
CREATE TABLE `ls_system_log_sms` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `scene` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '场景编号',
  `mobile` varchar(11) NOT NULL DEFAULT '' COMMENT '手机号码',
  `content` varchar(255) NOT NULL DEFAULT '' COMMENT '发送内容',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '发送状态：[0=发送中, 1=发送成功, 2=发送失败]',
  `results` text COMMENT '短信结果',
  `send_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '发送时间',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统短信日志表';

-- ----------------------------
-- Records of ls_system_log_sms
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_teacher
-- ----------------------------
DROP TABLE IF EXISTS `ls_teacher`;
CREATE TABLE `ls_teacher` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `number` int(11) NOT NULL COMMENT '编号',
  `name` varchar(16) NOT NULL COMMENT '姓名',
  `avatar` varchar(128) NOT NULL COMMENT '头像',
  `gender` tinyint(1) NOT NULL COMMENT '性别：1-男；2-女',
  `synopsis` varchar(255) DEFAULT NULL COMMENT '简介',
  `introduce` text COMMENT '介绍',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态：1-上架；0-下架',
  `sort` int(10) NOT NULL DEFAULT '0' COMMENT '排序',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='讲师表';

-- ----------------------------
-- Records of ls_teacher
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_user
-- ----------------------------
DROP TABLE IF EXISTS `ls_user`;
CREATE TABLE `ls_user` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `sn` varchar(32) DEFAULT NULL COMMENT '会员码',
  `nickname` varchar(32) NOT NULL COMMENT '用户昵称',
  `avatar` varchar(256) NOT NULL COMMENT '用户头像',
  `real_name` varchar(16) DEFAULT NULL COMMENT '真实姓名',
  `mobile` varchar(15) DEFAULT '' COMMENT '手机号码',
  `gender` tinyint(1) DEFAULT '0' COMMENT '性别:0-未知；1-男；2-女',
  `user_money` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '用户余额',
  `total_order_amount` decimal(10,2) DEFAULT '0.00' COMMENT '消费累计额度',
  `total_order_num` int(11) DEFAULT '0' COMMENT '累计消费次数',
  `total_recharge_amount` decimal(10,2) DEFAULT '0.00' COMMENT '累计充值金额',
  `account` varchar(16) DEFAULT '' COMMENT '账号',
  `password` varchar(32) DEFAULT NULL COMMENT '密码',
  `salt` varchar(32) DEFAULT NULL COMMENT '密码盐',
  `login_time` int(11) DEFAULT NULL COMMENT '最后登录时间',
  `login_ip` varchar(15) DEFAULT '' COMMENT '最后登录ip',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  `register_source` tinyint(1) NOT NULL COMMENT '用户注册来源',
  `disable` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否禁用：1-是；0-否',
  `is_new` tinyint(1) DEFAULT NULL COMMENT '是否为新用户1:是；0不是',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '修改时间',
  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
  `user_points` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户表';

-- ----------------------------
-- Records of ls_user
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_user_auth
-- ----------------------------
DROP TABLE IF EXISTS `ls_user_auth`;
CREATE TABLE `ls_user_auth` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) NOT NULL COMMENT '用户id',
  `openid` varchar(255) NOT NULL COMMENT '微信openid',
  `unionid` varchar(255) DEFAULT '' COMMENT '微信unionid',
  `terminal` tinyint(1) NOT NULL DEFAULT '1' COMMENT '客户端类型：1-微信小程序；2-微信公众号；3-手机H5；4-电脑PC；5-苹果APP；6-安卓APP',
  `create_time` int(10) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `openid` (`openid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户授权表';

-- ----------------------------
-- Records of ls_user_auth
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_user_session
-- ----------------------------
DROP TABLE IF EXISTS `ls_user_session`;
CREATE TABLE `ls_user_session` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) NOT NULL COMMENT '用户id',
  `terminal` tinyint(1) NOT NULL DEFAULT '1' COMMENT '客户端类型：1-微信小程序；2-微信公众号；3-手机H5；4-电脑PC；5-苹果APP；6-安卓APP',
  `token` varchar(32) NOT NULL COMMENT '令牌',
  `update_time` int(10) DEFAULT NULL COMMENT '更新时间',
  `expire_time` int(10) NOT NULL COMMENT '到期时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='会话表';

-- ----------------------------
-- Records of ls_user_session
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_user_signin
-- ----------------------------
DROP TABLE IF EXISTS `ls_user_signin`;
CREATE TABLE `ls_user_signin` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned DEFAULT NULL COMMENT '用户id',
  `days` int(10) DEFAULT NULL COMMENT '连续签到天数',
  `last_signin_time` int(10) DEFAULT NULL COMMENT '最后一次签到时间',
  `signin_nums` tinyint(2) unsigned DEFAULT '0' COMMENT '用户可补签次数',
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  `delete_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of ls_user_signin
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ls_user_signin_log
-- ----------------------------
DROP TABLE IF EXISTS `ls_user_signin_log`;
CREATE TABLE `ls_user_signin_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned DEFAULT NULL COMMENT '用户id',
  `days` int(10) DEFAULT NULL,
  `signin_content` text COMMENT '签到奖励内容，用户已经获到的奖励内容，默认积分',
  `add_time` datetime DEFAULT NULL COMMENT '签到时间',
  `signin_type` tinyint(1) DEFAULT NULL COMMENT '签到类型1:签到；2:补签',
  `patch_time` bigint(11) DEFAULT NULL COMMENT '补签时间',
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of ls_user_signin_log
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
